Add Datafile

select FILE_NAME,TABLESPACE_NAME,bytes/1024/1024 size_MB,AUTOEXTENSIBLE
from dba_data_files where tablespace_name = '';






To add new datafile:

alter tablespace add datafile'' size 1G autoextend on maxsize 20G;

Note: Make sure correct path is entered and the correct datafile naming convention is followed as per the existing datafiles.


To extend existing datafile size:

alter database datafile '' resize 25G;