Home » RDBMS Server » Server Administration » Recycle of Sequence values
Recycle of Sequence values [message #369456] Mon, 25 September 2000 21:59 Go to next message
Daniel Lim
Messages: 3
Registered: September 2000
Junior Member
Hi all,

Is there a way to find out the number of times
a particular sequence values being recycled?

Thanks in advance!

warmest regards
Daniel Lim
Re: Recycle of Sequence values [message #369458 is a reply to message #369456] Tue, 26 September 2000 01:46 Go to previous message
Thierry Van der Auwera
Messages: 44
Registered: January 2000
Member
Hi Daniel,

Oracle sequences NEVER reuse any used values.
The only thing that can happen is when it reaches it's maximum value, and you said that it can start again from the beginning. It will start giving numbers again from the minimum value.
If you don't like that, alter your sequence that it may not do this.
And if you want to know if this is happened. You can not find out how much times it has spinned around. (But the maximum value is really high, so spinning around will take quite a while)

Greetings,

Thierry.
Previous Topic: Re: urgent: shifting of table from 1 tablespace to another
Next Topic: Re: db_block _size 4k
Goto Forum:
  


Current Time: Fri Mar 29 05:22:54 CDT 2024