!! Please do not post Off Topic to this List !!
As an 8.0 to 8.i migration tool, Oracle provided a checklist for upgrades
(Metalink note 133920.1). This note has a couple of scripts that do a full
export, then awk the dmp into a somewhat reasonable script.
You'd need to play with it a bit to get preciely what you need, but I
believe all the pieces might be there . . .
HTH
Barb
> ----------
> From: Deshpande, Kirti[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, September 12, 2001 10:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: export user definitions
>
> I thought Joe was working on some kewl tool to address processing of
> exported dump file to get some meaningful SQL out ....
> Am I right, Joe?
>
> - Kirti Deshpande
> Verizon Information Services
> http://www.superpages.com
>
> > -----Original Message-----
> > From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, September 12, 2001 5:40 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: export user definitions
> >
> > True - I was hoping to skip over that and have no-one
> > notice :-)
> >
> > I've found on some platforms you can work around
> > because their grep, egrep, sed, nawk or awk can often
> > go to longer lengths...Still, once I got above a few
> > hundred partitions on a table - nothing would help me!
> >
> > Cheers
> > Connor
> >
> > --- JOE TESTA <[EMAIL PROTECTED]> wrote: > but
> > some version of strings is brain dead and stops
> > > at 1024 characters.
> > >
> > > joe
> > >
> > >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
