Skip to Content
avatar image
Former Member

How to Change the AutoExtend "Unlimited" mode to particular Size in Tablespace???


In my ecc server oracle database PSAPSR3 Table space Auto extend mode shown as Unlimited ,how can change it a particular size.??? 

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 18, 2014 at 04:37 PM

    Hi Arun,

    You can make the autoextend off using

    ALTER DATABASE DATAFILE '<path of datafile under PSAPSR3700>' AUTOEXTEND OFF;

    Change the maxsize to 32GB  keeping the autoextend on feature using

    alter database datafile '<path of datafile>' autoextend on maxsize 32000M;

    You may write a script to include commands for all the datafiles within the particular tablespace.

    Hope this helps.


    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • It will be good to have SAP application down to avoid any issues during the changes.

      Why ? Extending the MaxSize of a datafile doesn't permit the database from writing data into the datafile.

      I know it can be done online. Suggestion for having application down is to avoid any locking situation that may appear due to this activity. Just a safeguarding that's all.

  • avatar image
    Former Member
    Mar 19, 2014 at 09:30 AM


    You can use  BRTOOLS options to switch off the autoextend for PSAPSR3 table space, later you can resize and fix a maximum size for the tablespace in the BRTOOLS SPACE MGT options.

    Please let me know if you still want the step by step procedure.

    Thanks ,


    Add comment
    10|10000 characters needed characters exceeded