Skip to Content

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.

/wp-content/uploads/2015/06/1_729409.jpg

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

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

/wp-content/uploads/2015/06/2_729431.jpg

Note the data class used, here it is SLEXC.

/wp-content/uploads/2015/06/3_729432.jpg

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

/wp-content/uploads/2015/06/4_729433.jpg

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.

/wp-content/uploads/2015/06/5_729434.jpg

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

/wp-content/uploads/2015/06/6_729435.jpg

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply