| 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: How to export sequences with exp ?
To my knowledge, you can only choose to export an entire schema
in order to get at objects other than tables and indexes
(sequences, stored programs, views, etc.).
Thus an export with ROWS=N will give you all the structures without storing actual data. Then an import with SHOW=Y will list all these structures, albeit in a form that is not exactly DDL. You can massage that output to strip double quotes and join broken words to create DDL. I wrote a C program that was pretty bad that did exactly this to some degree, but the true solution would involve a proper DDL parser, (not for me today thanks).
Why doesn't Oracle Corp. realize the massive potential of a *good* import/export utility and produce one? e.g. Resizing tables, projecting storage, showing before hand dependancy trees, etc.
:-)
Akshay Jain
-----Original Message-----
From: Oliver Artelt [mailto:oli_at_md.transnet.de]
Sent: Wednesday, September 06, 2000 5:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: How to export sequences with exp ?
Hi,
maybe a
select 'CREATE SEQUENCE ' || SEQUENCE_NAME || ' START WITH ' || LAST_NUMBER
from user_sequences;
as a sql-Skript could be your way.
oli.
On Mit, 06 Sep 2000, Andreas Jung wrote:
> 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).
-- --- Oliver Artelt, System- und Datenbankadministration --------------------------------------------------------------- cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 10 email: oli@cubeoffice.de # web: http://www.cubeoffice.de --------------------------------------------------------------- -- Author: Oliver Artelt INET: oli_at_md.transnet.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 mayReceived on Tue Sep 19 2000 - 09:23:34 CDT
 |
 |