Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reset the sequence back?

741939Jul 21 2010 — edited Jul 21 2010

Dear all,

I am using a sequence named as "campus_site" and the current value is 850 and the next value will be 851.

I want the sequence starts will 100 without drop the sequence. I am using database version is 9.2.0.3.

Please advice.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2010

Added on Jul 21 2010

#general-database-discussions

7 comments

7,437 views