Max Size of an Auto Increment Sequence
406777Apr 8 2004 — edited Apr 8 2004Hello,
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?