I am currently installing the support stack to take us to patch level SAP BASIS 12 on CRM 5.0.
<b>ERROR in the DDIC_ACTIVATION phase and have failed due to an ORA-8102 error on DDFTX:</b>
Database error text: "ORA-08102: index key not found, obj# 16265, file
7, block 34280 (2)"
Internal call code.........: "[RSQL/DELE/DDFTX ]"
When I dig into things I find it is because of index DDFTX0. I am trying to drop and recreate the index, but get errors due to the "" using either:
drop index DDFTX~1 from DDFTX;
drop index "DDFTX~1" from DDFTX
ERROR at line 1:
ORA-00911: invalid character
<b>Connected thru SAPSR3</b>
SQL> DROP INDEX "DDFTX~0"
2 ;
DROP INDEX "DDFTX~0"
*
ERROR at line 1:
ORA-01418: specified index does not exist
SQL> DROP INDEX DDFTX~0
2 ;
DROP INDEX DDFTX~0
*
ERROR at line 1:
ORA-00911: invalid character
<b>Unable to drop index.
i tried from SE11 also. But same problem.
thanks in advace</b>