My Works/Oracle

[ORACLE] Manage Indexes

proud0 2009. 2. 9. 14:14
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];