Repairing unusable indexes in Oracle 10g

Learning objective

After completing this topic, you should be able to detect and repair unusable indexes.

Exercise overview

In this exercise, you're required to detect and repair unusable indexes in the orcl1 database.

This involves the following tasks:

• checking for unusable indexes
• repairing an index

Task 1: Checking for unusable indexes

Check the HR schema to make sure that the indexes it contains are all usable.

Steps list

Instructions
1. Select Administration
2. Select Indexes
3. Type HR
4. Click Go

Task 2: Repairing an index

You have discovered that the DEPT_ID_PK index in the HR schema is unusable, and you want to restore it to a valid status. You want the restoration to take place outside working hours, to minimize disruption.

Restore the selected DEPT_ID_PK index in the HR schema to a valid status. Schedule the restoration to take place later rather than immediately, to minimize disruption.

Steps list

Instructions
1. Select Reorganize from the Actions drop-down list
2. Click Go
3. Click Next
4. Click Next
5. Click Next
6. Select Later
7. Click Next
8. Click Submit Job