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

Andy and Knut,

Yes, I tried the SHOW=Y early on (I have used IMP and EXP many times), but it refuses to cooperate without the touser and fromuser being named, or FULL=Y specified. When I specify FULL=Y, I get loads of output (smaller than the dump file itself, to be sure) listing all the objects. 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.

I was hoping for something that would just list the user names, but this is all there is, I guess.

I'm using the version of IMP that came with Oracle 8i.

Thanks,

Anne

Andy Finkenstadt wrote:

> In <3CF4EFF2.AE30AC7E_at_enabletech.com> Anne Nolan <anolanNOSPAM_at_enabletech.com> writes:
> >Is there some option for the IMP utility or some other utility that
> >reports the users represented in a DMP file? I've done some searching
> >at google but haven't turned up anything yet. Maybe there's something
> >simple that I've overlooked.
>
> IMP ... SHOW=Y
>
>
Received on Thu May 30 2002 - 14:34:05 CDT