How to find out schemas from a dump file

[rpardip]

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

[sreddy]

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.

[Mr.Hanky]

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

[rpardip]

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 :(

[kgb]

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.

[rpardip]

kgb,

This is awesome. This worked out fine.