| Indices and sequences [message #58564] |
Wed, 17 September 2003 04:54  |
Sally
Messages: 3
Registered: September 2002
|
Junior Member |
|
|
|
Is it possible for a sequence on a primary key to be altered (i.e. reset) when dropping/creating an index on that primary key? Are there any possible scenarios where this could happen?
|
|
|
|
| Re: Indices and sequences [message #58565 is a reply to message #58564] |
Wed, 17 September 2003 07:07  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Sally,
I havent come across a situation yet where dropping/creating an index on the primary key affecting the sequence. Sequence is an independent database structure and is not confined to a specific key or a table and all it does is provide unique values .
Remember that sequence increments even when you dont use the values to insert into the primary or unique key(ie say when you rollback the transaction).
In case of Cached sequences,values may be lost when you do a 'alter system flush shared pool' or when there is a 'shutdown abort'. You could prevent this by altering the sequence to NOCACHE before flushing the shared pool.
HTH
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
