Oracle autoextend

Find datafiles in Oracle database which has autoextend turned on or off:

select file_id, tablespace_name, bytes, maxbytes, maxblocks, increment_by, file_name
from dba_data_files where autoextensible = 'YES';

Generate a script with dynamic SQL to change autoextend to ON or OFF:

select
'alter database datafile '||
file_name||
' '||
' autoextend off;'
from
dba_data_files;


select
'alter database datafile '||
file_name||
' '||
' autoextend on;'
from
dba_data_files;