| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export Sequences from a database
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C028BC.22CDE180
Content-Type: text/plain;
charset="iso-8859-1"
Joe, result of your approach will be DDL to create sequences - you can get it running query from dba_sequences spooling it into the file. More interesting is create SQL to recreate sequences with correct current values. Several approaches were discussed before in the list.
Alex Hillman
-----Original Message-----
From: Joseph S. Testa [mailto:teci_at_oracle-dba.com]
Sent: Wednesday, September 27, 2000 3:11 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Export Sequences from a database
here is how i get sequences from the .dmp file on the fly
solaris world:
mkfifo x.pipe
cat x.pipe | strings | grep -in "CREATE SEQUENCE" > /tmp/1.1 &
exp userid/password file=x.pipe rows=n
vi /tmp/1.1 and you got the create sequence statements
and soon as i get some free time i'll finish testing the ddl extractor pgm
from
the .dmp file utility :)
joe
PS: A CAVEAT, strings on solaris is brain dead after 1023 characters, it
just
truncates the input, get gnu binutils and compile it on your platform, that
version of strings i've had 30K lines with no problems.
Ruth Gramolini wrote:
> Export the schema of the owner of the sequences then import them with
> row=N. RBG
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, September 26, 2000 4:36 PM
>
> > hi, Everybody
> >
> > I created over 50 sequences in a schema and would like to import all
these
> > sequences to another database. How can I do that?
> > Thanks in advance for the info.
> >
> > Mosy Lo
> >
> > email: mlo_at_jcicorp.com
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mosy Lo
> > INET: mlo_at_JCICorp.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: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> 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: Joseph S. Testa INET: teci_at_oracle-dba.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). ------_=_NextPart_001_01C028BC.22CDE180 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Export Sequences from a database</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Joe, result of your approach will be DDL to create = sequences - you can get it running query from dba_sequences spooling it = into the file. More interesting is create SQL to recreate sequences = with correct current values. Several approaches were discussed before = in the list.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Joseph S. Testa [<A = HREF=3D"mailto:teci_at_oracle-dba.com">mailto:teci_at_oracle-dba.com</A>]</FON= T> <BR><FONT SIZE=3D2>Sent: Wednesday, September 27, 2000 3:11 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Export Sequences from a database</FONT> </P> <BR> <P><FONT SIZE=3D2>here is how i get sequences from the .dmp file on the = fly</FONT> </P> <BR> <P><FONT SIZE=3D2>solaris world:</FONT> </P> <P><FONT SIZE=3D2>mkfifo x.pipe</FONT> <BR><FONT SIZE=3D2>cat x.pipe | strings | grep -in "CREATE = SEQUENCE" > /tmp/1.1 &</FONT> <BR><FONT SIZE=3D2>exp userid/password file=3Dx.pipe rows=3Dn</FONT> </P> <P><FONT SIZE=3D2>vi /tmp/1.1 and you got the create sequence = statements</FONT> </P> <P><FONT SIZE=3D2>and soon as i get some free time i'll finish testing = the ddl extractor pgm from</FONT> <BR><FONT SIZE=3D2>the .dmp file utility :)</FONT> </P> <P><FONT SIZE=3D2>joe</FONT> </P> <BR> <P><FONT SIZE=3D2>PS: A CAVEAT, strings on solaris is brain dead = after 1023 characters, it just</FONT> <BR><FONT SIZE=3D2>truncates the input, get gnu binutils and compile it = on your platform, that</FONT> <BR><FONT SIZE=3D2>version of strings i've had 30K lines with no = problems.</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>Ruth Gramolini wrote:</FONT> </P> <P><FONT SIZE=3D2>> Export the schema of the owner of the = sequences then import them with</FONT> <BR><FONT SIZE=3D2>> row=3DN. RBG</FONT> <BR><FONT SIZE=3D2>> ----- Original Message -----</FONT> <BR><FONT SIZE=3D2>> To: "Multiple recipients of list = ORACLE-L" <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>> Sent: Tuesday, September 26, 2000 4:36 = PM</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> > hi, Everybody</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > I created over 50 sequences in a schema = and would like to import all these</FONT> <BR><FONT SIZE=3D2>> > sequences to another database. How = can I do that?</FONT> <BR><FONT SIZE=3D2>> > Thanks in advance for the info.</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Mosy Lo</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > email: mlo_at_jcicorp.com</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > --</FONT> <BR><FONT SIZE=3D2>> > Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> > --</FONT> <BR><FONT SIZE=3D2>> > Author: Mosy Lo</FONT> <BR><FONT SIZE=3D2>> > INET: mlo_at_JCICorp.com</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Fat City Network = Services -- (858) 538-5051 FAX: (858) = 538-5051</FONT> <BR><FONT SIZE=3D2>> > San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> > = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > To REMOVE yourself from this mailing list, = send an E-Mail message</FONT> <BR><FONT SIZE=3D2>> > to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> > the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > (or the name of mailing list you want to = be removed from). You may</FONT> <BR><FONT SIZE=3D2>> > also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Ruth Gramolini</FONT> <BR><FONT SIZE=3D2>> INET: = rgramolini_at_tax.state.vt.us</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Joseph S. Testa</FONT> <BR><FONT SIZE=3D2> INET: teci_at_oracle-dba.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =Received on Wed Sep 27 2000 - 14:50:06 CDT
 |
 |