on 08-19-2007 11:08 PM
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
go in DB02 and refresh reports.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.