Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to export sequences with exp ?

RE: How to export sequences with exp ?

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 6 Sep 2000 13:43:11 -0400
Message-Id: <10611.116317@fatcity.com>


It's easy to extract the ddl from dba_sequences. Probably there is some script in metalink to do this.

Regards

Waleed

-----Original Message-----
From: Andreas Jung [mailto:ajung_at_sz-sb.de] Sent: Wednesday, September 06, 2000 10:34 AM To: Multiple recipients of list ORACLE-L Subject: How to export sequences with exp ?

I need to export some sequences with exp. But I don't want to export the full
database to get the sequences exported. Because sequences are not bound to a table "TABLES=..." don't export a sequence.

Any idea how to do this ?

Thanks,
Andreas

-- 
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

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 06 2000 - 12:43:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US