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.