We help IT Professionals succeed at work.

Change the cache for an Oracle Sequence from 20 to 0

bionicbabe
bionicbabe asked
on
I need to change the cache for an Oracle sequence from 20 to zero, is it just as simple as

alter sequence schema.sequencename nocache;

Thanks

Rebecca
Comment
Watch Question

Most Valuable Expert 2011
Top Expert 2012
Commented:
yes - it is that simple

if you're concerned with if it's correct or not,  create a new sequence and test the syntax on it first to confirm.