Re: List of schemas in datapump file

  • From: Aaron Leonard <aachleon@xxxxxxxxx>
  • To: gnovikov@xxxxxxxxxxx
  • Date: Mon, 9 Nov 2009 15:29:23 -0600

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: