MISSING_INDEX

[Former Member]

hi Gurus,

Check database In DB13 showing the following error.

In se16 and se11 these tables are not existing. But these tables are shown in se14.

How can I rectify these error from Check Database fo DB13

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.USR02O

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZDDFTX

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZDDFTX

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZZCSKA

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZZCSKB

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZZCSKU

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZZSKA1

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZZSKAT

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.ZZSKB1

[former_member195313]

Go to DB13 and check the output of "Check DB" if still there are some MISSING_INDEX entries then you should REBUILD them with following command ;

alter index <SCHEMA.INDEX_NAME> rebuild tablespace TABLESPACE_NAME;

Repeat the DB13 "Check DB" should be everything is green.

DB13 Warning CHECKDB Missing Index Situation | SAPBASISINFO

[Former Member]

I tried this and got the following error message.

ORA-01418: specified index does not exist.

I am getting the same issue on the TABLE TJHDDXTT.  It is an SAP table.  no index created on it as yet.  It is in tablespace PSAPSR3USR according to my research.

so my syntax was:

alter index SAPSR3.TJHDDXTT rebuild tablespace PSAPSR3USR;

Note: I executed the following and got no rows returned.

select index_name, tablespace_name from dba_indexes where table_name='TJHDDXTT';

also executed the following

select index_name, tablespace_name from dba_indexes where tablespace_name='PSAPSR3USR';

11 rows selected but none has the table name I am looking for.

The index needs to be CREATED not rebuilt as it doesn't exist in the database at all.  Doesn't appear in SE14 either but when I am in DB02>>Diagnostics>> Missing tables and Indexes>>it shows up under unknown objects in abap dictionary.  double-clicking on it - I can see the table fields the table is made up of but nothing else is allowed.

How do I fix this error?

[Former Member]

It seems these tables were created at database level, but not in SAP.

Find out who did it, tell this person not to do so, and ask whether the tables may be dropped at database level.

regards

[debasissahoo]

HI,

While searching in SE11, are you giving the table name only?.. if not check it again,, by giving for example, ZDDFTX in SE11.

If these index are missing, you may create it in SE14.

Regards,

Debasis.

[Former Member]

I Have re-checked in SE11.

SE11 shows, eg: ZDDFTX doesnot exist. Check name

When I gone se14 and tried to create the index

se14 shows,

No active nametab exists for ZDDFTX

Kindly help

HI,

While searching in SE11, are you giving the table name only?.. if not check it again,, by giving for example, ZDDFTX in SE11.

If these index are missing, you may create it in SE14.

Regards,

Debasis.

[Former Member]

Hi Vijay,

The index may be missing in the database so what you can do go to DB02 click on missing index and select the index and click on create in DB.The index will be created.

Regards

Ashok

[Former Member]

in db02 --> missing indexes

All are in green , ie nothing to create

but in db02 it shows

Missing in R/3 DDIC 9 , 0

Please Help