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
---------------------------------------------------------------