Determine user from export dmp file

[slicendice]

Hi
I am trying to import a DMP file created from an Oracle export of a database that is used by an forms application. The export was apparently done as user SYSTEM, but I need to try and find out what the application user is called so that I can use the FROMUSER and TOUSER parameters during the import.
Does anyone know of any way to find the username(s) containted within an Oracle dmp file?

Thanks very much

 

[SantaMufasa]

Slice,

Perhaps the easiest way to determine the original user schema that owned the object(s) is to:

imp full=y file=<your export dump file> indexfile=yada.sql userid=<username>/<password>

...then display "yada.sql" to see the name of the original owner in each of the "CREATE INDEX..." entries.

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:00 (14Jul04) UTC (aka "GMT" and "Zulu"), 11:00 (14Jul04) Mountain Time)

 

[SantaMufasa]

Slice,

I should, perhaps, clarify that if/when you use my code suggestion, above, it does not import anything into the database since you are using the "indexfile" option.

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:39 (14Jul04) UTC (aka "GMT" and "Zulu"), 11:39 (14Jul04) Mountain Time)

 

[slicendice]

Many thanks santa - worked a treat!