Unable to create Index on DB

Hi Experts,

As part of SPDD we have to create an Index on EDIDC which was deleted during upgrade. I could recreate the index in ABAP dictionary, but its not getting created in DB. I used SE14 to create it, but got this below error:

I later tried to create it will the name Z01. Same error again. Can you help me out?

-

Request: Create Index EDIDC-900 (KGCD893/08.08.08/17:46)

Process: ukapx060_2

Nametab of table EDIDC with status A does not exist

sql:

CREATE

INDEX "EDIDC_{900" ON "EDIDC}"

("MANDT",

"ARCKEY")

PCTFREE 10

INITRANS 002

TABLESPACE PSAPBTABI

STORAGE (INITIAL 0000000016 K

NEXT 0000010240 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001)

ORA-00942: table or view does not exist

DDL time(___1): .........2 milliseconds

The SQL statement was not executed

Index could not be created completely in the database

Index EDIDC-900 could not be created

Request for EDIDC could not be executed

Index could not be created completely in the database

Message no. DI006

Diagnosis

It was not possible to create the index in the database.

This could be caused by the fact that an index with the same name exists in the database, but it is unknown to the ABAP/4 Dictionary. Activating the index in the ABAP/4 Dictionary is possible, but it is not possible to create it in the database.

Procedure

For more information about the cause of the error, analyze the SQL error messages in this log.

-

Regards,

Ravikanth