ALTER INDEX [schema.] index { { { deallocate_unused_clause | allocate_extent_clause } | parallel_clause | physical_attributes_clause | { LOGGING | NOLOGGING } } [ { deallocate_unused_clause | allocate_extent_clause } | parallel_clause | physical_attributes_clause | { LOGGING | NOLOGGING } ]... | rebuild_clause | PARAMETERS ( 'alter_index_params' ) | { ENABLE | DISABLE } | UNUSABLE | RENAME [PARTITION partition] TO new_name | COALESCE | { MONITORING | NOMONITORING } USAGE | UPDATE BLOCK REFERENCES | alter_index_partitioning } ;
For information on the symbols and conventions of Backus-Naur Form (BNF) syntax, see Appendix A.