Oracle分区交换
zx@ORCL>alter index idx_t1_id rebuild;Index altered.
zx@ORCL>alter index idx_t1_name rebuild partition p1;
Index altered.
zx@ORCL>select index_name,status from user_indexes where index_name like 'IDX_T1%';
INDEX_NAME STATUS
------------------------------------------------------------------------------------------ ------------------------
IDX_T1_NAME N/A
IDX_T1_ID VALID
zx@ORCL>select index_name,partition_name,status from user_ind_partitions where index_name like 'IDX_T1%';
INDEX_NAME PARTITION_NAMESTATUS
------------------------------------------------------------------------------------------ --------------- ------------------------
IDX_T1_NAME P1 USABLE
IDX_T1_NAME P2 USABLE
IDX_T1_NAME P3 USABLE
zx@ORCL>alter table t1 exchange partition p1 with table t2 update indexes ;
Table altered.
zx@ORCL>select index_name,status from user_indexes where index_name like 'IDX_T1%';
INDEX_NAME STATUS
------------------------------------------------------------------------------------------ ------------------------
IDX_T1_NAME N/A
IDX_T1_ID VALID
zx@ORCL>select index_name,partition_name,status from user_ind_partitions where index_name like 'IDX_T1%';
INDEX_NAME PARTITION_NAMESTATUS
------------------------------------------------------------------------------------------ --------------- ------------------------
IDX_T1_NAME P1 UNUSABLE
IDX_T1_NAME P2 USABLE
IDX_T1_NAME P3 USABLE
页:
[1]