Missing index problem

[Former Member]

Hi Gurus!

I have a critical problem to solve.

I have a table without data which is inconsistent because it doesn't have the primary index. When i see missing indexes at DB02, the system tells me that the index is created, but when i go to SE14 and select the primary index, it says the index does not exists on the database and the only option that is active is the one to create the index. If I try to create the index, i get an error saying: there is already a an object named 'zmed_distr~0' ( my index name ).

Can anybody help me?

Thank you in advance.

[Former Member]

Go to SE14 and press the 'indexes' button. Select your index and then press the 'create database index' button.

rob

[Former Member]

I Rob.

Thanks for your answer.

I have already done that. The problem is that i get an error saying there is already an object created withe that name. the two buttons "Adjust and activate" and "Delete index" are deactivated. The index appears to be created at DB02. It seems the index is created on DB but not in ABAP DICTIONARY.

[Former Member]

OK - exactly what did you do when trying what I suggested?

Rob

[Former Member]

the tsystem does'nt create the index and give me this log:

Request: Create Index ZMED_DISTR-0 (FORM05/11.12.07/19:06)

Process: BLADE04_0

sql:

ALTER TABLE [ZMED_DISTR]

ADD CONSTRAINT [ZMED_DISTR~0]

PRIMARY KEY CLUSTERED

( [MANDT] ,

[ZUONR] ,

[GJAHR] ,

[KUNNR] ,

[ESTAB] ,

[TXT20] ,

[REPS] )

There is already an object named 'ZMED_DISTR~0' in the database.Could

not create constraint. See previous errors.

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

The SQL statement was not executed

Index could not be created completely in the database

Index ZMED_DISTR-0 could not be created

Request for ZMED_DISTR could not be executed