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
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.
That trick of using TAORA and the Data Class to find all the tables in a given table space is neat 🙂
Thanks Martin 🙂
The tablespace i got in my error was PSAPTEMP for which I didn't get any data class in TAORA. I would like to discuss a few more things. Since you are an expert in this area. Let me know your ID and I will get in touch with you with details. Thanks!