Maximum index limit in Oracle10g- can we reset?

[Div Raj]

Hi,

As I'm working in a Real Time Project, the database now contains 22digit indexes. We're using Oracle10g.
I want to know, whether we can set the Index to reset(to start from 0th Index) when it reaches the limit.

Please help me...


Thanks
-------

[Paul Campbell]

You need the CYCLE clause in your sequence DDL. If it does not have a max value... you will need to add it to the Alter below (for example of max... look at the create that follows the alter code).

To alter it

ALTER SEQUENCE your_sequence
   CYCLE;

To create it...

 
CREATE SEQUENCE your_sequence 
    START WITH 1 MAXVALUE 9999999999999999999999  
    CYCLE;
 

I'd be surprised if you hit your limit any time soon.
[ November 24, 2008: Message edited by: Paul Campbell ]

[Div Raj]

Thankyou Paul

But could you please tell me for what is the CYCLE clause used in sequence?


Thanks
-------

[Div Raj]

Hi,

I got it.

CYCLE clause we use if we want to force the sequence to start all over again once it hits the maximum value

Thankyou

[Avi Abrami]

Div,
When all else fails, read the [Oracle] documentation.
For your information, documentation for nearly all Oracle versions can be accessed from:

http://www.oracle.com/technology/documentation/database.html

Good Luck,
Avi.
[ November 24, 2008: Message edited by: Avi Abrami ]

[Div Raj]

ThankYou Avi