-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|