Re: How to tell what users/schemas are in a DMP file

>So, I have to direct the output to a log file, and then go
>through the log file, looking for the word "importing" to find all the
>users in the dump file.

If you are using unix, or Windows NT with Cygwin installed,

imp userid=scott/tiger_at_instance full=y show=y log=something.log

grep -i importing something.log

alternatively, use NOTEPAD to look at something.log and Find... to find the importing statements.

andy

-- 
Andrew Finkenstadt (http://www.finkenstadt.com/andy/)