Skip to Content
0
Former Member
Apr 22, 2009 at 10:15 AM

Set "autoextend = off" for all datafiles

874 Views

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