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=yfollowed by'strings' on the
file..hthconnor--- 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:> <A
href="http://www.orafaq.com">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:> <A
href="
http://www.orafaq.com">
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> <A
href="
http://explorer.msn.com/intl.asp">
http://explorer.msn.com/intl.asp>
> -- > Please see the official ORACLE-L FAQ:> <A
href="
http://www.orafaq.com">
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 <A
href="
http://www.oradba.freeserve.co.uk)">
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 <A
href="
http://mail.yahoo.co.uk">
http://mail.yahoo.co.ukor your free
@yahoo.ie address at <A
href="
http://mail.yahoo.ie">
http://mail.yahoo.ie-- Please see the
official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author:
=?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc_at_yahoo.co.ukFat
City Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Wed Sep 12 2001 - 11:42:40 CDT
