René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Alter index in Oracle

Alter index ... split partition

This is one of the few statements that can make use of the nologging option.

Alter index ... rebuild

This is one of the few statements that can make use of the nologging option.

Alter index ... rebuild partition

This is one of the few statements that can make use of the nologging option.

alter index ... unusable

.... Yet to be finished ....
See also using the +append hint with insert statements for a possible use to set an index to unusable.

alter index ... [no]monitoring usage

An index can be monitored to verify if it is used within the period between
SQL>alter index index_name monitoring usage; -- and
SQL>alter index index_name nomonitoring usage;
The result is stored in v$object_usage.