Re: Strange problem with Sequence.. please help..

> If you restart the Oracle instance/database
> the cached numbers will be lost.

Additionally, the sequence number are cached in the Dictionary Cache. Depending on activity and the configuration of your server, it is possible for the
sequence information to get aged out of the cache. So you can lose sequence numbers without a restart of the instance.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown