Re: Sequence - Cache expire ?

Ender Wiggin wrote:
>
> Hi,
> Does anyone know when Oracle expires/discards the cache for sequence except
> oracle shutdown/start ? System is Oracle 8i/Solaris. Thanks

• flush
• normal aging of sequence
• alter sequence

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."