rpardip,

So what is the solution if I want to generate the next sequence is 60005934, do I have to drop the sequence and recreate it????

How do I prevent this happen in the future b/c I do cold backup every night which mean that I have to bounce the instance every night???

Thanks


[Edited by ashley75 on 05-29-2002 at 05:38 PM]