OracleDB‎ > ‎

Datafile

DataFile Autoextend

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;


Comments