Script for Auto Extend off/on On Datafiles on Database

To Turn Off Auto Extend On Data files:-

select 'alter database datafile '''||file_name||''' AUTOEXTEND OFF;' from   dba_data_files where  autoextensible='YES';


To Turn On Auto Extend On Data files:-


select 'alter database datafile '''||file_name||''' AUTOEXTEND ON;' from   dba_data_files where  autoextensible='OFF';


For Temp files:-

select 'alter database tempfile '''||file_name||''' AUTOEXTEND OFF;' from   dba_temp_files where  autoextensible='YES';


select 'alter database tempfile '''||file_name||''' AUTOEXTEND ON;' from   dba_temp_files where  autoextensible='OFF';