| Recycle of Sequence values [message #369456] |
Mon, 25 September 2000 21:59  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
