cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to create Index on DB

former_member187668
Participant
0 Kudos
1,289

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 "EDIDC900" 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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

1. Use Tcode SE11

2. Give table EDIDC

3. Click on display table

4. Goto Utilities--> click on Db utility --> Create/recreate for existing indexes.

Regards,

Srini Nookala

former_member187668
Participant
0 Kudos

Still the same problem Srini.

Regards,

Ravikanth

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Ask to Basis Team, creating Indexes for EDIDC table in Database side.

Later, you can check through SE11.

Do you have full permissions in SAP?

Regards,

Srini Nookala

former_member187668
Participant
0 Kudos

Okay I shall ask the Basis team to do that. The user id I used doesnt have full access. But I can get it if required.

Regards,

Ravikanth

Former Member
0 Kudos

Hi,

Tell me onething, presently howmany indexes are there in EDIDC table.

If, EDIDC~900 is there, delete it and try it for same.

Also check in Database side.

Regards,

Srini Nookala

former_member187668
Participant
0 Kudos

Hi Srini,

SAP provided 4 indexes. I plan to create one. Initially I was trying with the name Z01. It gave error. So I started trying with 900. Still the problem persist. So I tried creating a different index with different fields. Still couldnt solve the problem.

I posted it to our basis team to check. They say everythign is fine. So got struck here. Any specific things you want to check in DB?

Thanks for your efforts.

Regards,

Ravikanth

Former Member
0 Kudos

Hi,

Nametab of table EDIDC with status A does not exist

Check this table is active or not, if not activate it using by SE11 tcode.

Delivery Class should be "A" in Delivery and maintenance.

Regards,

Srini Nookala

former_member187668
Participant
0 Kudos

Yes Srini. Its active with delivery status A.