Skip to Main Content

Oracle Database Discussions

Announcement

Testing banner

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 :)

Comments
Post Details
Added on Nov 10 2020
8 comments
4,327 views