cancel
Showing results for 
Search instead for 
Did you mean: 

SE11 / DB02 - checking index

Former Member
0 Kudos

Hi,

I am working with ECC 5.0, Oracle 10.2

When looking at DB02, it showed couple of primary and secondary indexes are missing.

I tried checking in SE11. But I am not sure, which way is correct.

When I entered the table name in SE11 and clicked diplay, it showed Table field etc.

1)Then I clicked on "Indexes" button on top and it showed indexes.

2) Then, I tried with pull-down menu Utilities -> Database Objects -> Display.

This does not show any indexes.

which way is correct.? or is there better way to acertain?

Thanks,

Sam

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hi,

The primary index of a table is <b>not </b>shown in SE11 -> Indexes.

That is for the seconday indexes.

Probably that is the one that is missing.

Go to SE14. Then check if the primary index exist. If it does not exist you can create it from there (if you do not have duplicated keys)

former_member204746
Active Contributor
0 Kudos

go in DB02 and refresh reports.

Former Member
0 Kudos

Dear Sam,

What I think is ur talking about the critical space in which is shows the missing tables and indexes.The correct way what i think is select the table name and goto se14 .This is where you can correct the size.

Hope its helpful to you.

Regards,

Amit