Adding a datafile in Tablespace

Use the 'Alter Tablespace' SQL statement to add a datafile in a tablespace.

Alter tablespace <tablespace_name> add datafile 'file_name' size int_value [K|M];

e.g.

Alter Tablespace USERS add datafile '/u01/oracle/oradata/orcl/user02.dbf' size 100M;



Have a question or comment? Post it below!