Question Re: Missing Tables and Indexes in Technology Q&A

Missing Tables and Indexes

Former Member — Tue, 31 Jan 2012 13:40:20 GMT

Hi all,

we have checked "missing table and indexs" status with DBACOCKPIT and there it show 362 Indexes are not created.

all are the standard table indexes.

we have updated the indexes and statistics with BRCONNECT also.and its complited successfully.after this also "it show 362 Indexes are not created". we are using SOLARIS OS and oracle database.

Can anybody help me out how to rebuilt the missing indexes .....plz mention the steps.

Thanks,

Rableen khurana

Re: Missing Tables and Indexes

Former Member — Tue, 31 Jan 2012 13:50:43 GMT

Hi,

Refer to the note and lins on how to fix it

Note 1320008 - DBA Cockpit: Selection in "Missing Tables and Indexes"

http://wiki.sdn.sap.com/wiki/display/TechTSG/(DB)IndexReportedasMissing

http://help.sap.com/saphelp_nwpi711/helpdata/en/33/5b277b8b0745b8b60e67ca04c77ebb/content.htm

Thanks,

Arjun

Re: Missing Tables and Indexes

former_member204080 — Wed, 01 Feb 2012 04:47:13 GMT

Hi,

see this thread.

Re: Missing Tables and Indexes

Former Member — Wed, 01 Feb 2012 07:54:16 GMT

Hi Rableen,

In transaction code DB02 you can click button missing indexes. On the result screen , you can select each missing index and from the menu click on "Create in DB" button. Schedule the job in background .

Monitor it the job progress using Tcode SM37.

You need to repeat the process for each missing index you need to re-create.

Regards,

Deepak Kori

Re: Missing Tables and Indexes

Former Member — Thu, 02 Feb 2012 12:28:48 GMT

Hi all,

Can u tell me how to rebuilt the indexes with using brtools ?

Thanks,

Rableen

Re: Missing Tables and Indexes

Former Member — Thu, 02 Feb 2012 13:40:38 GMT

Hi,

If you issue is "Index is missing", you can restore index in transaction SE14.

For rebuilt index with BRTOOLS follow the steps:

1. Execute BRTOOLS with user DB

2. Option 3 "segment Mangement"

3. Option 2 "reubilt indexes"

4. Select option 6 and put table o tables.

5. Set parameters for running and finish

Regards,

William Neira