Missing Index issue.

[Former Member]

Dears,

I am getting following error in DB02 in Missing index option.

Missing indexes. Check of 19.07.2008 07:04:31

Indexes missing in the database

Primary indexes 1

ZRECEIPTS-0

Secondary indexes 6

BSIS-ZCH

BSIS-ZGL

EKBE-M01

GLPCA-BL

MBEW-ZMK

ZCND-CD

Please suggest how to resolve this issue.

Deepak

[Former Member]

Issue Resolved..

[Former Member]

Hi,

I created Indexes maually but in one index its showing:

Request: Create Index ZCND-CD (ANKITG/19.07.08/10:19)

Process: MSLDEV_1

sql:

CREATE UNIQUE INDEX "ZCND~CD" ON "ZCND"

("MANDT",

"STATS")

PCTFREE 10

INITRANS 002

TABLESPACE PSAPDS1

STORAGE (INITIAL 0000000016 K

NEXT 0000000016 K

MINEXTENTS 0000000001

MAXEXTENTS UNLIMITED

PCTINCREASE 0000

FREELISTS 001)

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

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

The SQL statement was not executed

Index could not be created completely in the database

Index ZCND-CD could not be created

Request for ZCND could not be executed

Please suggest.

Deepak