I have create table space in Oracle with Alter command ., But when I check this one via DB02 .DBA data file . it show NO autoextensible . what the mean of autoextensible . and IF I want to do autoextensible YES. Then what to do for autoextensible.
alter database datafile '<YOUR_FILE_NAME>' autoextend on;
If u make autoextent on you cannot monitor increasing your tablespace and spare many - many free space of hardisk,
Sometimes it leads to peformance, database will be hung up
If there is no space to extent the tablespacespace,
you can change the tablespace setup into auto exchange
like this, ex increas 10% :
SQL>ALTER TABLESPACE "DATA" DEFAULT STORAGE ( PCTINCREASE
it's better you use no autoextent the tablespace, you can
resize each datafile to increas your freespace in
tablespace or get a biggest block.
SQL> alter database datafile '<datafile_name>' resize
If u want to add a datafile
SQL> alter database add datafile '/disk1/BASE/DATA.ora1'
you must login as user which grant DBA
Edited by: bhaskar1818 on Jul 17, 2008 12:27 PM