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!

INTEGER max reached....

1006594Jul 2 2013 — edited Jul 3 2013

Oracle 11gR2

I wanted to know if anyone has experienced reaching the maximum INTEGER range of 2147483648. We are approaching this value quickly. It is on a PK column that is generated using a sequence.

I know we can change the datatype to NUMBER(p,s) but we would possibly run into locking the entire table (which is quite big) for that time.

Any other ideas?

Thanks.

This post has been answered by Greg Spall on Jul 2 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2013

Added on Jul 2 2013

10 comments

3,585 views