Skip to Content
avatar image
Former Member

SE11 / DB02 - checking index

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 20, 2007 at 03:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 20, 2007 at 01:34 PM

    go in DB02 and refresh reports.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 20, 2007 at 07:34 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded