DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: sequence cache

  1. #1
    Join Date
    Jul 2000
    Posts
    68
    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?

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    20 is the default. You can alter the sequence specifying cache/nocache.

  3. #3
    Join Date
    Jul 2000
    Posts
    68
    Thanks.

    Could I change the default value?

  4. #4
    Join Date
    Jul 2000
    Posts
    296
    No, you can't change the default. You have to specify cache/nocache when creating sequences if you don't want the default.

  5. #5
    Join Date
    Sep 2000
    Posts
    5
    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
  •  


Click Here to Expand Forum to Full Width