space critical objects

[Former Member]

Hi,

I have space sritical objects in DB02.

Can anybody advise me how i solve this problem?

Tablespace :PSAPES620

Object :D010TAB

Type :Table

Freespace/kb

Maximum Total

1.056.640 1.653.824

Next extent/kb

8192

AutoExt.

Stat

red

Thanks

[Former Member · Accepted solution]

Hi

Try to add the datafile, as the autoextension is off.

You can do this by the help of SAPDBA/BRTOOLS.

You would get the stuff related to BRTOOLS in hep.sap.com portal.

Just go thorugh this link

, may be it would help you out a bit.

If you get error in starting the brtools, just check the environmental variables like ORACLE_SID, ORACLE_HOME etc.

Thanks