Results 1 to 3 of 3

Thread: index rebuild

  1. #1
    Join Date
    Apr 2003

    Unanswered: index rebuild

    What if I am rebuilding the index for deleted row entries & not for storage or ts. Than how will I check the status if the index is rebuild. Why the status in dba_indexes remains same (i.e, as when you analyzed the index) even after rebuilding it.

    When the STATUS will be UNUSABLE in the dba_indexes.

  2. #2
    Join Date
    Apr 2003

    One of the case when index becomes unusable is when you move the table from one tablespace to another. In such cases All the indexes of that tables becomes UNUSABLE.

    You need to rebuild the indexes in such case.


  3. #3
    Join Date
    Apr 2002
    California, USA

    Thumbs up

    First you query the DBA_INDEXES, then the DBA_OBJECTS. You will see the current index status and when was last rebuilt:

    SQL> SELECT status FROM dba_indexes WHERE owner = ' ';

    SQL> SELECT last_ddl_time FROM dba_objects WHERE object_type = 'INDEX' ADN owner = ' ';

    Hope that helps,

    clio_usa - OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts