Increasing the size of a tablespace in Oracle

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 ) ;