Skip to Main Content
Forums

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!

update all sequences

11g.DBAMar 20 2013 — edited Mar 20 2013
Hi,

My database has several sequences generated for each table to auto increment the particular column every time an insert is done in the table.
but my problem is that "last_number" column in all sequences is default set to 1 but the column has several values.So is there any script to update all sequence automatically using the max value for the particular column or has to manually update all the sequences.

Thanx
This post has been answered by Nicolas Gasparotto on Mar 20 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2013
Added on Mar 20 2013
#general-database-discussions
6 comments
2,877 views