Re: A sequence problem

Yes you can do that, but it sounds to me that you have a very un scalable application. May be it doesn't have to scale, and if that is true why not just store a number in a table that you update accordingly.

Anjo.

Violin wrote:

> 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 - 03:26:32 CST