Repairing unusable indexes in Oracle 10g
After completing this topic, you should be able to detect and repair unusable indexes.
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
HR schema to make sure that the indexes it contains are all usable.
|1. Select Administration|
|2. Select Indexes|
| 3. Type |
|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.
|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|