The best thing that I've ever seen to scan the export file is DBATool
by DataBee. It also works under influence (wine). I haven't tested it
against 10g, that is planned for the incoming Saturday.
On 02/19/2004 08:55:49 AM, Robert Stauffer wrote:
> Adam,
>
> Might the impshow2sql script (or a modification of it) in Metalink
> note 297=
> 65.1 be what you're looking for?
>
> Bob Stauffer
> D&E Communications
> Ephrata, PA USA
> 717-738-8737
> rstauffer_at_decommunications.com
>
> >>> adonahue_at_opsware.com 02/18/2004 17:29:25 >>>
> Folks,
>
> Anyone have a pre-written script to scan an imp show=3Dy log file
> for=20
> those statements necessary to create a user, grant it system
> privileges=20
> and roles, prior to performing a fromuser/touser import of its
> schema?
> =20
> I figured someone must have done this before. Otherwise, I'll
> quickly=20
> come up with one.
>
> Thanks,
>
> Adam
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org=20
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/=20
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20
> -----------------------------------------------------------------
>
>
>
>
> **DISCLAIMER
> This e-mail message and any files transmitted with it are intended
> for
> the =
> use of the individual or entity to which they are addressed and may
> contain=
> information that is privileged, proprietary and confidential. If you
> are n=
> ot the intended recipient, you may not use, copy or disclose to
> anyone
> the =
> message or any information contained in the message. If you have
> received t=
> his communication in error, please notify the sender and delete this
> e-mail=
> message. The contents do not represent the opinion of D&E except to
> the ex=
> tent that it relates to their official business.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 19 2004 - 08:30:22 CST
