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!

How can I reset the value of a sequence ?

simon87Nov 10 2020 — edited Nov 10 2020

Hi,


How can I reset the value of a sequence, without alter, drop permissions.
When deleting some records in the table, some values are left empty in the sequence

Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Thank you for your support :)

Added on Nov 10 2020

#12c, #general-database-discussions, #identity, #sql

8 comments

7,018 views

2 mentions