Skip to Content
author's profile photo Former Member
Former Member

Missing Tables and Indexes

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2012 at 01:50 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 01, 2012 at 04:47 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 01, 2012 at 07:54 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.