Parameter type – Boolean
Default value – True
Modifiable – ALTER SESSION, ALTER SYSTEM
Range of values – True | False
The skip_unusable_indexes enables or disables the use and reporting of tables with unusable
indexes or index partitions.
True – Disables error reporting of indexes and
index partitions marked UNUSABLE. This setting allows all operations
(inserts, deletes, updates, and selects) on tables with unusable
indexes or index partitions. Note: If an index is used to enforce a
UNIQUE constraint on a table, then allowing insert and update
operations on the table might violate the constraint. Therefore,
this setting does not disable error reporting for unusable indexes
that are unique.
False – Enables error reporting of indexes
marked UNUSABLE. This setting does not allow inserts, deletes, and
updates on tables with unusable indexes or index partitions.
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details: