Skip to Main Content
Forums

SQL & PL/SQL

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!

incrementing sequence

609621Apr 4 2010 — edited Apr 4 2010
Dear all,

10.2.0.3 on solaris 10..


Accidentally, I ran the below command in the production database (this is very critical)

select 'ALTER SEQUENCE '||sequence_name||' INCREMENT BY 10000;' from user_sequences;

How I can revert it back ?

Kai
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2010
Added on Apr 4 2010
4 comments
1,114 views