Oracle - Add tablespace / datafile

Increase Size of Tablespace/Datafile

A tablespace can be resized either by increasing the size of the current datafiles, or by adding additional datafiles. By using AUTOEXTEND the datafiles can be increased automatically.

A RESIZE will only work upward if there is enough space in the file system. A RESIZE downwards will only work if there is enough unallocated space available that can be released.

You can use M, G, and T to size the files: megabytes, gigabytes, terabytes.

Increase the size of the datafile example:

SQLPLUS> alter database datafile 1 autoextend on next 50M maxsize 2000M;

Add an additional datafile example:

SQLPLUS> alter tablespace system add datafile '+DEVDATA' size 50M;