sequence cache

[wwalice]

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?

[akkerend]

20 is the default. You can alter the sequence specifying cache/nocache.

[wwalice]

Thanks.

Could I change the default value?

[akkerend]

No, you can't change the default. You have to specify cache/nocache when creating sequences if you don't want the default.

[ntokozo]

You could also specify the value you want
in the CACHE clause of your ALTER /
CREATE SEQUENCE statement.

success?
ntokozo