Skip to Content
0
Former Member
Jan 15, 2013 at 03:22 PM

Cannot drop index

552 Views

Dear All,

during EHP2 installation (CRM) we faced a problem on MAIN_SHDIMP/SUBMOD_SHDIMP/SHADOW_IMPORT_INC phase:

{code}

2EETW000 Update and insert sequence failed due to conflicting unique indexes on table COMC_ATTRIBUTE

{code}

We have tried everything including changing index in se11, then activating in se14, but still nothing. As far as we know the last solution is to drop existing index on db level and create new one but non-unique. Sounds easy, but...

{code}

SQL> select index_name, owner, visibility from dba_indexes where table_name='COMC_ATTRIBUTE' and tablespace_name='PSAPSR4';

INDEX_NAME OWNER VISIBILIT

------------------------------ ------------------------------ ---------

COMC_ATTRIBUTE~UNI SAPSR4 VISIBLE

COMC_ATTRIBUTE~0 SAPSR4 VISIBLE

SQL> drop index sapsr4.COM_ATTRIBUTE~UNI;

ORA-00911: invalid character

SQL> drop index sapsr4."COM_ATTRIBUTE~UNI";

ORA-01418: specified index does not exist

{code}

We've tried tens of options like single and double quotes, but still nothing. Please advice how to drop this index..

Thanks in advance!