Re: sequenceS REPLICATION

Let say you want you sequence to be 1000, so you do it by alter sequence:

spool inc_seq.sql
select 'alter sequence myseq increment by '

   || 1000 - currval.myseq || ';' from dual; select 'select nextval.myseq from dual;' from dual; select 'alter sequence myseq increment by 1;' from dual; spool off
@inc_seq.sql

Do not forget all the set option off you need to get clean script in the sql file. Also do some testing because I am sure there should be -1 somewhere in the first alter sequence.

you can also drop the sequence and simply build a new one with MINVALUE 1000.

Yechiel Adar
Mehish

--
http://www.freelists.org/webpage/oracle-l