--查询索引
根据表名查询索引:
selectowner,index_name,tablespace_name,status from dba_indexes wheretable_name='ODS_ST_GSM_BTS_H';
查询用户下索引:
selectowner,index_name,index_type,table_owner,table_name,table_type,partitioned fromdba_indexes where owner='ODSDB_KPI';
--分区索引
selectindex_owner,index_name,partition_name,STATUS from dba_ind_partitions whereindex_name='IPX_ODS_ST_GSM_CEL_H';
重建分区索引:
alter index IPX_OP_RE_ST_GSM_CEL rebuild partitionP20170910;