'NEXT' Parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 'NEXT' Parameter

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi guys,
    I am a little confused as to what exactly the NEXT parameter with the auto extend clause does in the follwing snippet. Can someone help me?

    create tablespace rbs1_ts
    DATAFILE '$BASE_DIR/rbs01.dbf' SIZE 128M REUSE
    AUTOEXTEND ON NEXT 5120K
    MINIMUM EXTENT 512K
    DEFAULT STORAGE ( INITIAL 512K NEXT 512K
    MINEXTENTS 8 MAXEXTENTS 4096);

    We have kept the initial and next values as 512K in the default storage parameters, so when does the extent with 5120K come in to effect? And also, is it correct to keep it 10 times the size mentioned in the default parameters?
    thanks
    manjunath

  2. #2
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    The NEXT used w/ autoextend tells Oracle how much the datafile should "grow" whenever it needs to be extended. In the example you give, this is saying "whenever the datafile needs to be extended, request another 5M of drive space from the operating system".

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    thanks, carp
    manjunath

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