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?
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".