Skip to Content
avatar image
Former Member

Set "autoextend = off" for all datafiles

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 22, 2009 at 10:36 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 22, 2009 at 12:51 PM

    ALTER DATABASE DATAFILE filename2

    AUTOEXTEND OFF;

    Regards.

    Sarbajit

    Add comment
    10|10000 characters needed characters exceeded

    • if you would have run CHEKDB in DB13 once a day, you would have received warnings about autoexent size being too big for your partition. Are you running that job?

  • avatar image
    Former Member
    Apr 22, 2009 at 05:31 PM

    I use to have the same problem but I prefer to use de BR*tools 'cause its easier and in this mode you'll have logs, and you can see the real status of your datafiles.

    My 2 cents.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded