Hi,
I created a sequence without specifying the cache/nocache. But when i checked the sequence the cache number was 20. What happened? Is it oracle default? How to change the default?
Printable View
Hi,
I created a sequence without specifying the cache/nocache. But when i checked the sequence the cache number was 20. What happened? Is it oracle default? How to change the default?
20 is the default. You can alter the sequence specifying cache/nocache.
Thanks.
Could I change the default value?
No, you can't change the default. You have to specify cache/nocache when creating sequences if you don't want the default.
You could also specify the value you want
in the CACHE clause of your ALTER /
CREATE SEQUENCE statement.
success?
ntokozo