在重建分區表的索引時是否會引起其他分區或者其他分區的索引失效

显示全部楼层 · 2011-2-18 11:43:33

很困擾很糾結的問題，謝謝各位捧場！

千问 · 2011-2-18 11:43:33

试一试就知道拉,用不着纠结,呵呵
如果是local index的话不会的
select INDEX_NAME,INDEX_OWNER,PARTITION_NAME,STATUS from DBA_IND_PARTITIONS where index_name='IDX_1';
INDEX_NAME
INDEX_OWNER
PARTITION_NAME
STATUS
------------------------------ ------------------------------ ------------------------------ --------
IDX_1
SYS
P1
UNUSABLE
IDX_1
SYS
P2
UNUSABLE
IDX_1
SYS
P3
USABLE
IDX_1
SYS
P4
USABLE
IDX_1
SYS
P5
USABLE
alter index IDX_1 rebuild partition P1 online;
Index altered.
select INDEX_NAME,INDEX_OWNER,PARTITION_NAME,STATUS from DBA_IND_PARTITIONS where index_name='IDX_1';
INDEX_NAME
INDEX_OWNER
PARTITION_NAME
STATUS
------------------------------ ------------------------------ ------------------------------ --------
IDX_1
SYS
P1
USABLE
IDX_1
SYS
P2
UNUSABLE
IDX_1
SYS
P3
USABLE
IDX_1
SYS
P4
USABLE
IDX_1
SYS
P5
USABLE