How to find out schemas from a dump file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How to find out schemas from a dump file

  1. #1
    Join Date
    Sep 2000
    Posts
    155
    Is there a way to find out the schema/user names that are in an export dump file? I have an export dump from a vendor and I am not sure if the export was done using FULL=Y or FULL=N and I have no information about the users/schemas as well that are in the dump file. Any pointers???


    TIA

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Not sure about the easy way of doing it but, using import parms SHOW=Y or INDEXFILE=Y you can acheive what you wanted to know from the dump files.

    Reddy,Sam

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    This is a great reason why it is a good idea to use a parfile and to save your .LOG files from the export. We always put the .LOG and .DMP together this way there is never a question. This issue was raised yesterday, that is why I am again stressing this point.

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Sep 2000
    Posts
    155
    Mr.Hanky,

    Its a good suggestion. Thanks!
    I always do that. However, this particular dump file
    that I have was sent by a vendor without any
    information :(

  5. #5
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    If you are in unix try to use this:

    []/u03> grep 'CONNECT ' file_name.dmp

    CONNECT TRAX
    CONNECT TRAX_
    CONNECT TRAX_
    CONNECT DIMA
    CONNECT TRAX_STAT
    CONNECT SYSTEM
    CONNECT DIMA
    CONNECT SYSTEM
    CONNECT DBSNMP
    CONNECT TRAXSPUSER
    CONNECT TRAXSPMGR
    CONNECT TRAXGLUSER
    CONNECT TRAXGLMGR
    CONNECT TRAXFFUSER
    CONNECT TRAXFFMGR
    CONNECT QCONFIG
    CONNECT SYSTEM
    CONNECT DIMA
    CONNECT TRAX
    CONNECT TRAX_
    CONNECT OUTLN
    ........


    Connect means schema name is in dump file, when you find out scheemas, test it.
    Best wishes!
    Dmitri

  6. #6
    Join Date
    Sep 2000
    Posts
    155
    kgb,

    This is awesome. This worked out fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width