To see if a datafile automatically grow.
SELECT file_name,autoextensible FROM dba_data_files;
Turn on autoextend
alter database datafile 'file_name' autoextend on;
