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!

Max Size of an Auto Increment Sequence

406777Apr 8 2004 — edited Apr 8 2004
Hello,

I apologize if this question is asked alot. I searched the forum and really didnt get the answer I'm looking for. I also tried google with no luck.

I'm using 8i. I have a table that is going to have 10,000 - 30,000 rows. I want to use an auto-increment sequence to assign a specific value to each row.

I've used the following code to create the sequence:
CREATE SEQUENCE auto_increment start with 1 increment by 1 nomaxvalue

I know that I have specified 'nomaxvalue' but I'm wondering, is there a limit to how large the auto-increment sequence can be? Perhaps a maximum amount of characters or a specific max value?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2004
Added on Apr 8 2004
5 comments
451 views