A sequence problem

  Dear All,

  If I create a sequence like this :
  create sequence myseq increment by 1 nocycle nocache;

 And use it for inserting rows into table:  select myseq.nextval into :new.col from dual;

 And assuming the last number of myseq is 123,  May I change the last_number to 10?
 (for some reason i have to do it ,
  such like deleting rows from 11th to 123th)  

 Is it possible? and how to?

 Or I just could do so?
 drop sequence myseq;
 create sequence myseq start with 10 increment by 1 nocycle nocache;

 Because I have lots of sequences , and insert triggers  drop and create sequence will cause many INVALID objects.

 I'm looking for a easy way.
 Thanks in advance.

 Best Regards,

 Violin.
 violin.hsiao_at_mail.pouchen.com.tw Received on Tue Mar 13 2001 - 02:29:54 CST