Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to tell what users/schemas are in a DMP file
Andy,
The Notepad 'find text' method is what I do already. I just wish there was an option to "just show me the user names and not all that other output". :)
Thanks,
Anne
Andy Finkenstadt wrote:
> >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/)
Received on Fri May 31 2002 - 09:50:55 CDT
![]() |
![]() |