Skip to Content
0
Former Member
Jun 11, 2007 at 05:03 AM

Problem with SPAM in CRM 5.0

25 Views

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>