Re: import sequence ... ?

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: Tue, 19 May 1998 13:55:58 +0200
Message-ID: <3561734E.F9150790@ubs.com>

Chan Wai Tong wrote:
>
> Hi,
>
> I would like to know how to import the current sequence number
> to a database without dropping the existing sequence.
>
> Thank you!
>
> Mike Chan

It's not exactly an import, but try following:

ALTER SEQUENCE xyz INCREMENT BY (your new value - old value);

select xyz.nextval from dual; (should put you to the new value)

ALTER SEQUENCE xyz INCREMENT BY (your old increment value);

rgds
eugen Received on Tue May 19 1998 - 06:55:58 CDT