Skip to Content
avatar image
Former Member

Related to DB02

Hi All,

We are using SAP ECC 6.0 on Oracle 10g. When we check in transaction code DB02 we get that our Tablespace PSAPSR3 is in Autoextend OFF mode. But all the datafiles for this Tablespace are Autoextendable.

So due to this problem we are getting confused as the space is still present in the datafiles but tablespace is almost 93% full.

Please suggest what needs to be done to move that Tablespace into Autoextend ON mode.

Regards,

Arun Pathak

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 24, 2009 at 11:59 AM

    Hello Arun,

    the autoextension property belongs to the data files, not the tablespace.

    There is no overall autoextend setting for a tablespace, e.g. in DBA_TABLESPACES

    so DB02 has to make up some setting which it will show in DB02 for the tablespaces.

    If all data files of tablespace PSAPSR3 are set to AUTOEXTEND ON, but have

    already reached their maximum size, then they all still show the AUTOEXTEND ON

    feature, but the tablespace PSAPSR3 cannot be exteneded automatically any more,

    so DB02 shows AUTOEXTEND OFF for the tablespace.

    Check this out:

    select file_name, bytes, maxbytes from dba_data_files where bytes<>maxbytes and tablespace_name='PSAPSR3';

    If this select returns no rows, then you have to add another datafile or raise maxbytes (if possible).

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mark,

      Thankyou very much for your response but as per our analysis there is sufficient space in the Datafiles of Tablespace PSAPSR3, but still the Tablespace is in Autoextend OFF mode.

      If even we add new Datafile with Autoextend ON there is no change in the Tablespace.

      Please suggest if you have any suggestions on this.

      Reagrds,

      Arun Pathak