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
>
>
> >>> hamcdc_at_yahoo.co.uk 09/12/01 09:15AM >>>
> exp rows=n full=y
>
> followed by
>
> 'strings' on the file..
>
> hth
> connor
>
> --- Rachel Carmichael <carmichr_at_hotmail.com> wrote:
> >
> nope, not using the indexfile definition you won't.
> > That way all you'll see
> > are table and index create statements.
> >
> > if you do a full import, using show=y and
> > log=<logname> you will get a file
> > that contains ALL statements that would recreate
> > your database. They aren't
> > particularly readable as oracle breaks lines in
> the
> > middle of words, but
> > it's a start.
> >
> > or you could just write SQL statements to generate
> > SQL... using the
> > dba_users, dba_ts_quotas, dba_roles, dba_tab_privs
> > and dba_sys_privs
> > views.
> >
> > >From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > >Subject: RE: export user definitions
> > >Date: Mon, 10 Sep 2001 04:10:18 -0800
> > >
> > >Do a full export ( without data, rows=n ) and
> > import with indexfile
> > >option. You can see all the information including
> > users.
> > >
> > >HTH,
> > >Rajesh
> > >
> > >
> > >-----Original Message-----
> > >Sent: Monday, September 10, 2001 1:45 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >hi everyone
> > >
> > >can anybody help me with a script that recreates
> > >user definitions and the granted roles ?
> > >
> > >thanks
> > >
> > >g.g. kor
> > >rdw ict groningen
> > >
> > >
> > >--
> > >Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > >--
> > >Author:
> > > INET: GKor_at_rdw.nl
> > >
> > >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: Rajesh Dayal
> > > INET: Rajesh_at_ohitelecom.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).
> >
> >
> >
>
> > Get your FREE download of MSN Explorer at
> > http://explorer.msn.com/intl.asp
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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).
>
> =====
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the
> statue"
>
>
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: hamcdc_at_yahoo.co.uk
>
> 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).
>
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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).
Received on Wed Sep 12 2001 - 16:40:38 CDT
