Hi!
My DB partittion seems to be full. Therefore I would like to set all for all the tablespaces with their datafile the autoextend on "off".
Then I will create a second DB partition where I will create additional data files.
Question:
What is the appropriate SQL-commando/skript to set up for all the datafiles the autoextend on state "off"?
With the following commando I can generate all the appropriate sql statements:
select 'alter database datafile '''||file_name||''' autoextend off;'
from dba_data_files
where AUTOEXTENSIBLE='YES';
Thank you very much!
regards