MAXDB/INDEXSTATEMENTS DB table is showing as an Unknown objects.

[Former Member]

Hi,

After database migration there is /MAXDB/INDEXSTATEMENTS DB table is showing as an Unknown objects in ABAP Dictionary. I tried to drop /MAXDB/INDEXSTATEMENTS but it says object doesnu2019t exist.

Please let me know how to drop/delete this object.

Thanks,

Narendra

[former_member188883]

Hi,

After you have performed an upgrade or an installation with R3load from SAP Basis Release 640, the following tables which are not listed in the DDIC may remain in the database:

/MAXDB/INDEXSTATE

/MAXDB/INDEXSTMTS

/MAXDB/INDEXSTMTS_NEW

/MAXDB/INDEXSTATEMENTS

The tables are created by R3load during the installation or upgrade and are only required for the load operation. You can delete the tables from the database.

In your situation, this table exists in the database but does not exist in abap dictionary. You need to check consistency of abap dictionary using se14 .

Drop the table from database.

Hope this helps.

Regards.

Deepak Kori

[former_member184473]

Hello Narendra,

Check in transaction SE14 if the table exists in the database or not.

If yes, you can proceed as following:

1) dbmcli -d <SID> -u <dbm user>,<dbm password> -uSQL <ABAP sql user>,<sql password>

2) sql_execute drop table "/MAXDB/INDEXSTATEMENTS"

Otherwise, check the following notes:

[1248769 - Inconsistency between database and ABAP Dictionary|http://service.sap.com/sap/support/notes/1248769]

[33814 - Warnings of inconsistencies between database & R/3 DDIC|http://service.sap.com/sap/support/notes/33814]

Regards,

Eduardo Rezende