Re: export user definitions
Hi, I wonder if I can get a copy of your utility. Regards, Mario Alberto Ramos >>> [EMAIL PROTECTED] 13/09/01 18:45 >>> !! Please do not post Off Topic to this List !! Here is what it does so far: first off you HAVE TO GET a versio of strings that is NOT brain dead, meaning it has to be able to handle extremely long lines, no 1024/2048 max line length, you can get free source code for a better strings command from gnu look for binutils package. ok that is covered: it handles: 1. sequences 2. analyze 3. comment on 4. grant 5. create table(yes normal, hash and range partitioned, no composite yet) 6. regular, bitmap and unique indexes 7. alter table 8. create synonym. Its far from done but it works pretty much for what i needed. Its alpha software at best and for a small database, its almost easier to use OEM and reverse the few tables needed. If there is interest, i'll upload what I have done to my website(its not the oracle-dba.com one, its the "the-testas.net" one. drop me a private email(not to the list). joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: Mario Alberto Ramos Arellano 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).
Re: export user definitions
!! Please do not post Off Topic to this List !! Here is what it does so far: first off you HAVE TO GET a versio of strings that is NOT brain dead, meaning it has to be able to handle extremely long lines, no 1024/2048 max line length, you can get free source code for a better strings command from gnu look for binutils package. ok that is covered: it handles: 1. sequences 2. analyze 3. comment on 4. grant 5. create table(yes normal, hash and range partitioned, no composite yet) 6. regular, bitmap and unique indexes 7. alter table 8. create synonym. Its far from done but it works pretty much for what i needed. Its alpha software at best and for a small database, its almost easier to use OEM and reverse the few tables needed. If there is interest, i'll upload what I have done to my website(its not the oracle-dba.com one, its the "the-testas.net" one. drop me a private email(not to the list). joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
RE: export user definitions
!! Please do not post Off Topic to this List !! I wrote a VBA script run from Access that will parse the CREATE INDEX and CREATE TABLE statements from the indexfile and also insert new storage parameters based upon the results found in a modified copy of DBA_TABLES and DBA_INDEXES. I used it once. But basically points out some need for Oracle to improve export and import. I should easily be able to have specific sets of DDL go to specific files if I want. - E >-Original Message- >From: Joe Testa [mailto:[EMAIL PROTECTED]] >Sent: Thursday, September 13, 2001 3:10 PM >To: Multiple recipients of list ORACLE-L >Subject: Re: export user definitions > > >!! Please do not post Off Topic to this List !! > >ahhhy yea, benn working on it for like 2 years(during my free time) :) > >joe >"Deshpande, Kirti" wrote: >> >> 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 >> > > >> > > > >-- >Joe Testa >Performing Remote DBA Services, need some backup DBA support? >For Sale: Oracle-dba.com domain, its not going cheap but feel free to >ask :) >IM: n8xcthome or joen8xct >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Joe Testa > 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). > -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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).
Re: export user definitions
!! Please do not post Off Topic to this List !! ahhhy yea, benn working on it for like 2 years(during my free time) :) joe "Deshpande, Kirti" wrote: > > 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 > > > > > > -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
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:[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).
Re: export user definitions
On Wednesday 12 September 2001 21:05, Deshpande, Kirti wrote:
> I thought Joe was working on some kewl tool to address processing of
> exported dump file to get some meaningful SQL out
Maybe this would work?
Far from perfect, it mostly massages the table definitions
into something manageable.
use it like:
imp userid=scott/tiger indexfile=ddl.txt file=expdat.dmp
indexfile_filter < ddl.txt > ddl.sql
Jared
--
#!/usr/bin/perl
=pod
indexfile_filter
create usable SQL from 'imp indexfile=myfile.sql'
e.g. indexfile_filter < myfile.sql > newfile.sql
=cut
my $ddl = undef;
while(<>) {
chomp;
# don't remove quotes!
# they are your friend for odd object names
#s/\"//g; # remove quotes
s/^REM\s+//;# uncomment
next if /^\s*$/; # blank line
next if /^CONNECT/;
# process current sql if defined and new command starting
if ( /^CREATE|ALTER/ ) {
if ( $ddl ) {
sqlFormat(\$ddl);
print "$ddl\n\n";
$ddl = '';
}
}
$ddl .= $_;
}
sqlFormat(\$ddl);
print "$ddl\n";
sub sqlFormat {
my ($sqlRef) = @_;
#
my $parsed = ${$sqlRef};
if ( ${$sqlRef} =~ /^CREATE\sTABLE/ ) {
$parsed =~ s/
^([\w\s\d\"\.\$]+) # match to first paren
(\(.+\){1}?)# get column definitions
(.+)# the junk in
the middle
(\([\w\s\d\$\"]+\)) # last set of parens
(.*)$ # to the end
of the line
/undef/x; # can replace with junk
# as
we have parsed text
my @sqlParts = ( $1, $2, $3, $4, $5 );
#$sqlParts[0] = ${$sqlRef};
for $i ( 0 .. $#sqlParts ) {
if ( $sqlParts[$i] =~ /,/ ) {
# newline after opening paren
$sqlParts[$i] =~ s/^(.*)(\()(\")(.+)$/$1$2\n $3$4/;
# newline before comma following closing paren
$sqlParts[$i] =~ s/\),/\)\n ,/g;
# newline before comma following data type e.g. DATE
$sqlParts[$i] =~ s/(\w),/$1\n ,/g;
# newline after closing paren
$sqlParts[$i] =~ s/\)$/\n\)/;
}
}
${$sqlRef} = join("\n",@sqlParts);
}
}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
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).
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).
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 > > > >>> [EMAIL PROTECTED] 09/12/01 09:15AM >>> > exp rows=n full=y > > followed by > > 'strings' on the file.. > > hth > connor > > --- Rachel Carmichael <[EMAIL PROTECTED]> 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= 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 <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > >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: [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: Rajesh Dayal > > > 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). > > > > > > > _ > > 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: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > >
RE: export user definitions
but some version of strings is brain dead and stops at 1024 characters. joe >>> [EMAIL PROTECTED] 09/12/01 09:15AM >>>exp rows=n full=yfollowed by'strings' on the file..hthconnor--- Rachel Carmichael <[EMAIL PROTECTED]> 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= 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 <[EMAIL PROTECTED]>> >Reply-To: [EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L> <[EMAIL PROTECTED]>> >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: [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: Rajesh Dayal> > 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).> > >_> 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: [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). =Connor McDonaldhttp://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.ukor 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: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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).
RE: export user definitions
exp rows=n full=y followed by 'strings' on the file.. hth connor --- Rachel Carmichael <[EMAIL PROTECTED]> 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= 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 <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >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: [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: Rajesh Dayal > > 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). > > > _ > 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: [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). = 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: [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).
RE: export user definitions
something like this i have found on teamdba.com
select 'create user '||username||' identified by values '
||chr(39)||password||chr(39)||
' default tablespace '||default_tablespace ||
' temporary tablespace '|| temporary_tablespace||' ;'
from dba_users
where username not in ('SYS','SYSTEM','DBSNMP','OUTLN');
> -Oorspronkelijk bericht-
> Van: Jared Still [SMTP:[EMAIL PROTECTED]]
> Verzonden: maandag 10 september 2001 15:47
> Aan: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Onderwerp:Re: export user definitions
>
> On Monday 10 September 2001 02:45, [EMAIL PROTECTED] wrote:
> > hi everyone
> >
> > can anybody help me with a script that recreates
> > user definitions and the granted roles ?
> >
> > thanks
> >
> > g.g. kor
> > rdw ict groningen
>
> Someone asked this just a couple of weeks ago. That
> script will recreate a user.
>
> Take a look through the archives at www.fatcity.com for this.
>
> Recreating the roles is a simple exercise I'll leave to you.
>
> Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
RE: export user definitions
Thanks...for update... MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Mon, 10 Sep 2001 10:10:19 -0800 Mohammed, No, I have not found a solution for it. IBM-AIX does that too. I have several tables with partitions, and the ddl for it is never complete, if I used strings. So I use it for things that do not have long SQL statements. For others, I use scripts or 3rd party tools. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From:Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] > Sent:Monday, September 10, 2001 11:40 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: export user definitions > > Kirti, > I found problem with strings on HP-UX. If create table line is long it > cuts > it. In Oracle Financials create tables scripts are very long and while > converting dmp file to txt file it cuts a lot of stuff. Do you know any > work > around for this problem. I never observed this problem with NCR UNIX. > Regards > > MOHAMMAD RAFIQ > > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Mon, 10 Sep 2001 05:10:24 -0800 > > Rajesh, > I am afraid indexfile option will not show such information. > If using exported dump file is opted for such information, then it has > to > be extracted using either 'strings' command (UNIX) or by importing using > the > show=y log= option. The logfile will then have to be edited to > fish > out the required information, which may need quite a bit of editing to get > a > working SQL. I like the 'strings' better for such tasks. > > HTH, > > Regards, > > - Kirti Deshpande >Verizon Information Services > http://www.superpages.com > > > -Original Message- > > From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, September 10, 2001 7:10 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: export user definitions > > > > 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: [EMAIL PROTECTED] > > > > > -- > 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). > > > _ > 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: Mohammad Rafiq > 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: export user definitions
Mohammed, No, I have not found a solution for it. IBM-AIX does that too. I have several tables with partitions, and the ddl for it is never complete, if I used strings. So I use it for things that do not have long SQL statements. For others, I use scripts or 3rd party tools. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 10, 2001 11:40 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: export user definitions > > Kirti, > I found problem with strings on HP-UX. If create table line is long it > cuts > it. In Oracle Financials create tables scripts are very long and while > converting dmp file to txt file it cuts a lot of stuff. Do you know any > work > around for this problem. I never observed this problem with NCR UNIX. > Regards > > MOHAMMAD RAFIQ > > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Mon, 10 Sep 2001 05:10:24 -0800 > > Rajesh, > I am afraid indexfile option will not show such information. > If using exported dump file is opted for such information, then it has > to > be extracted using either 'strings' command (UNIX) or by importing using > the > show=y log= option. The logfile will then have to be edited to > fish > out the required information, which may need quite a bit of editing to get > a > working SQL. I like the 'strings' better for such tasks. > > HTH, > > Regards, > > - Kirti Deshpande >Verizon Information Services > http://www.superpages.com > > > -Original Message- > > From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, September 10, 2001 7:10 AM > > To:Multiple recipients of list ORACLE-L > > Subject: RE: export user definitions > > > > 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: [EMAIL PROTECTED] > > > > > -- > 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). > > > _ > 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: Mohammad Rafiq > 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: 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).
RE: export user definitions
Kirti, I found problem with strings on HP-UX. If create table line is long it cuts it. In Oracle Financials create tables scripts are very long and while converting dmp file to txt file it cuts a lot of stuff. Do you know any work around for this problem. I never observed this problem with NCR UNIX. Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Mon, 10 Sep 2001 05:10:24 -0800 Rajesh, I am afraid indexfile option will not show such information. If using exported dump file is opted for such information, then it has to be extracted using either 'strings' command (UNIX) or by importing using the show=y log= option. The logfile will then have to be edited to fish out the required information, which may need quite a bit of editing to get a working SQL. I like the 'strings' better for such tasks. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From:Rajesh Dayal [SMTP:[EMAIL PROTECTED]] > Sent:Monday, September 10, 2001 7:10 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: export user definitions > > 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: [EMAIL PROTECTED] > > -- 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). _ 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: Mohammad Rafiq 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).
RE: export user definitions
what kind of options you use in 'strings' command? There is one option like 'strings -a | -'. When I tried this option on dump file, it didn't work. Thanks in advance! Lucy Lin On Mon, 10 Sep 2001, Deshpande, Kirti wrote: > Rajesh, > I am afraid indexfile option will not show such information. > If using exported dump file is opted for such information, then it has to > be extracted using either 'strings' command (UNIX) or by importing using the > show=y log= option. The logfile will then have to be edited to fish > out the required information, which may need quite a bit of editing to get a > working SQL. I like the 'strings' better for such tasks. > > HTH, > > Regards, > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, September 10, 2001 7:10 AM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: export user definitions > > > > 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: [EMAIL PROTECTED] > > > > > -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lucy Lin 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).
Re: export user definitions
On Monday 10 September 2001 02:45, [EMAIL PROTECTED] wrote: > hi everyone > > can anybody help me with a script that recreates > user definitions and the granted roles ? > > thanks > > g.g. kor > rdw ict groningen Someone asked this just a couple of weeks ago. That script will recreate a user. Take a look through the archives at www.fatcity.com for this. Recreating the roles is a simple exercise I'll leave to you. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
RE: export user definitions
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= 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 <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >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: [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: Rajesh Dayal > 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). _ 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: [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).
RE: export user definitions
Thanks a lot for correcting me,I just remembered the basic idea and missed the real stuff ( SHOW=Y AND LOG=) Too Busy with some bugsNpatches of 8.1.7 ;-)) Rajesh -Original Message- Sent: Monday, September 10, 2001 4:10 PM To: [EMAIL PROTECTED]; Rajesh Dayal Rajesh, I am afraid indexfile option will not show such information. If using exported dump file is opted for such information, then it has to be extracted using either 'strings' command (UNIX) or by importing using the show=y log= option. The logfile will then have to be edited to fish out the required information, which may need quite a bit of editing to get a working SQL. I like the 'strings' better for such tasks. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 10, 2001 7:10 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: export user definitions > > 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: [EMAIL PROTECTED] > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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).
RE: export user definitions
Rajesh, I am afraid indexfile option will not show such information. If using exported dump file is opted for such information, then it has to be extracted using either 'strings' command (UNIX) or by importing using the show=y log= option. The logfile will then have to be edited to fish out the required information, which may need quite a bit of editing to get a working SQL. I like the 'strings' better for such tasks. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 10, 2001 7:10 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: export user definitions > > 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: [EMAIL PROTECTED] > > -- 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).
RE: export user definitions
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: [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: Rajesh Dayal 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).
export user definitions
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: [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).
