Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to tell what users/schemas are in a DMP file

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

From: Anne Nolan <anolanNOSPAM_at_enabletech.com>
Date: Fri, 31 May 2002 07:50:55 -0700
Message-ID: <3CF78DCF.42B55DFB@enabletech.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US