Related to DB02

[Former Member]

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

[Former Member]

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

[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