[ORACLE] Manage Indexes

Coalesce

Global Index

alter index [index_owner].[index_name] coalesce;

Partitioned Index

alter index [index_owner].[index_name] modify partition [partition_name] coalesce;

Rebuild

Global Index & Partitioned Index

alter index [index_owner].[index_name] rebuild partition [partition_name];