Re: List of schemas in datapump file

From: Aaron Leonard <aachleon_at_gmail.com>
Date: Mon, 9 Nov 2009 15:29:23 -0600
Message-ID: <34f494ce0911091329k797fdf6fka6cc9dea0902165d_at_mail.gmail.com>

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_at_dulcian.com>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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 09 2009 - 15:29:23 CST