RE: export user definitions

!! 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:kirti.deshpande_at_verizon.com]
> Reply To: ORACLE-L_at_fatcity.com
> 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:hamcdc_at_yahoo.co.uk]
> > 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 <JTESTA_at_longaberger.com> 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: kirti.deshpande_at_verizon.com
>
> 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: ListGuru_at_fatcity.com (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: bakerb_at_rockymountainnews.com

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: ListGuru_at_fatcity.com (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).