DB02 Index name not fully displayed (18 chars only displayed)

[Former Member]

Hi Guys,

In DB02 under missing Tables and indexs of Diagnostics (UNKNOWN OBJECTS

IN ABAP DICTIONARY), the DB index name is not getting displayed fully.

For ex. some of the indexes looks same (4&5 , 6&7). In Db02 the unknown

index name getting displayed is as below; I had noticed that all the

indexes

is having only 18 characters in the db02 output where as in actual it

is not the case.

where as the output from SQL command is showing the complete name of

unknown index.

Pls let us know how to get the indexes displayed with full name in DB02

which should be same as SQL Command Output.

1: SMDB_/FRE/MATLOC_F

2: SMDB_ZTIL_STG_TSD_

3: SMDB_ZTIL_CON_TSD_

4: SMDB_/FRE/BIF_TSD_

5: SMDB_/FRE/BIF_TSD_

6: SMDB_/SAPAPO/MATLO

7: SMDB_/SAPAPO/MATLO

8: SMDB_/FRE/TS_TAB01

select INDEX_NAME,TABLE_OWNER,TABLE_NAME from dba_indexes where

index_name like '%SMDB%';

INDEX_NAME TABLE_OWNER TABLE_NAME

======================= ========== ==============

SMDB_/FRE/MATLOC_FRP_I1 SAPSR3 /FRE/MATLOC_FRP

SMDB_ZTIL_STG_TSD_I1 SAPSR3 ZTIL_STG_TSD

SMDB_ZTIL_CON_TSD_I1 SAPSR3 ZTIL_CON_TSD

SMDB_/FRE/BIF_TSD_I1 SAPSR3 /FRE/BIF_TSD

SMDB_/FRE/BIF_TSD_I2 SAPSR3 /FRE/BIF_TSD

SMDB_/SAPAPO/MATLOC_I1 SAPSR3 /SAPAPO/MATLOC

SMDB_/SAPAPO/MATLOCTD_I1 SAPSR3 /SAPAPO/MATLOCTD

SMDB_/FRE/TS_TAB01_D_I1 SAPSR3 /FRE/TS_TAB01_D

Regards,

Mani

[former_member66264]

you do not mension yourrelease, but could you run into this error:

73577 Oracle Ext. check: Index names are truncated

318396 Fields for table and index names too short in DB02

Rgds

Nico