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???
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.
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.
I remember when this place was cool.
Its a good suggestion. Thanks!
I always do that. However, this particular dump file
that I have was sent by a vendor without any
If you are in unix try to use this:
/u03> grep 'CONNECT ' file_name.dmp
Connect means schema name is in dump file, when you find out scheemas, test it.
This is awesome. This worked out fine.
Click Here to Expand Forum to Full Width