Increasing the size of a tablespace

Increasing the size of a tablespace

1) Add a data file

ALTER TABLESPACE ts03
ADD DATAFILE
'/data1/oradata/ts03-b.dbf'
SIZE 200M ;

ALTER TABLESPACE ts01
ADD DATAFILE
'/data/disk12/dataxx44.dbf' SIZE 200M
AUTOEXTEND ON NEXT 10M
MAXSIZE 500M;


2) or, resize current data file

alter database datafile '/u01/oradata/orcl/users01.dbf' resize 50M;



3) or, change the storage / extent configuration

ALTER TABLESPACE ts01
DEFAULT STORAGE (
INITIAL 200M NEXT 200M MAXEXTENTS 10 ) ;




/* Altering the default storage for a tablespace */

ALTER TABLESPACE TEMP01 DEFAULT STORAGE (PCTINCREASE 0)

ALTER TABLESPACE TEMP01 DEFAULT STORAGE ( initial 1M next 1M )