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
>
>
>

References:

Reading and converting ALL_TAB_COL_STATISTICS
From: Martin Klier

Re: Reading and converting ALL_TAB_COL_STATISTICS
From: Martin Berger

List of schemas in datapump file
From: Grigoriy Novikov

Re: List of schemas in datapump file

Other related posts: