Runtime Errors DBIF_RSQL_SQL_ERROR;Error Text of the Database: “ORA-01653: unable to extend table in table space”

This document will explain you the analysis steps when you get run time error DBIF_RSQL_SQL_ERROR with error text ORA-01653: unable to extend table.

Run time error details:

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                   CX_SY_OPEN_SQL_DB

SQL error 1653 when accessing table “DDFTX”.

Error Text of the Database: “ORA-01653: unable to extend table SAPSR3.DDFTX by 1024 in table space PSAPSR3731″.

Check in transaction DB02 for the table space memory. Here you can see there is no free memory in the table space PSAPSR3731 which has caused runtime error.

Contact BASIS and increase the memory of the table space to avoid the runtime error.

How to find the Table space for the given database table?

Go to transaction SE11 –> Display table and go to Technical settings.

Note the data class used, here it is SLEXC.

Go to table TAORA, give the data class name and find the table space.

How to find all tables under a given table space?

Lets find the tables under table space PSAPSR3731.

Go to table TAORA and give the table space name to get the Data class assigned to it.

Now go to table DD09L give the above data class to find the database tables assigned to the table space.