Skip to Main Content

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!

Sequence MAX_VALUE is reached.

DBA AssociateNov 13 2013 — edited Nov 14 2013

Hi,

I wish to add records (200,000 +) to the oracle table(500 at a time).

This table uses a sequence named Test_SEQ, the max value has been reached.

Sequence MAX_VALUE is 1,000,000 and its LAST_NUMBER is 1,000,000.

I believe that the Test_SEQ is used to populate the PDF_ID field.

I cannot add more rows without increasing these values or somehow

re-sequencing or re-creating the table. Please advise. Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2013
Added on Nov 13 2013
5 comments
4,200 views