Re: List of schemas in datapump file

You can extract the ddl from the dumpfile using the sqlfile parameter and
then grep through the output file for the create user statements.

impdp directory=mydir dumpfile=mydumpfile.dmp sqlfile=mydumpfile.sql
grep -i "create user" mydumpfile.sql


On Mon, Nov 9, 2009 at 8:39 AM, Grigoriy Novikov <gnovikov@xxxxxxxxxxx>wrote:

> Hello list,
>
> Is it possible to get list of schemas/users from 10.2 datapump file?
>
> Thanks in advance.
>
>
> Grigoriy Novikov
> Dulcian, Inc.
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: