关于重建LOB字段的表后是否需要重建LOB索引（试验）

SQL> create table test123
  2    (t clob)
  3   lob(t) store as (disable storage in row);
 
Table created

SQL> select SEGMENT_NAME,SEGMENT_TYPE,tablespace_name from user_segments;
 
SEGMENT_NAME                                                                     SEGMENT_TYPE       TABLESPACE_NAME
-------------------------------------------------------------------------------- ------------------ ------------------------------
SYS_IL0000053986C00001$$                                                         LOBINDEX           PPZHU
SYS_LOB0000053986C00001$$                                                        LOBSEGMENT         PPZHU
TEST123                                                                          TABLE              PPZHU
 
SQL> alter table test123 move tablespace ooo;
 
Table altered
SQL> select SEGMENT_NAME,SEGMENT_TYPE,tablespace_name from user_segments;
 
SEGMENT_NAME                                                                     SEGMENT_TYPE       TABLESPACE_NAME
-------------------------------------------------------------------------------- ------------------ ------------------------------
SYS_IL0000053986C00001$$                                                         LOBINDEX           PPZHU
SYS_LOB0000053986C00001$$                                                        LOBSEGMENT         PPZHU
TEST123                                                                          TABLE              OOO
 SQL> alter table test123 move lob(t) store as( tablespace ooo);
 
Table altered
 
SQL> select SEGMENT_NAME,SEGMENT_TYPE,tablespace_name from user_segments;
 
SEGMENT_NAME                                                                     SEGMENT_TYPE       TABLESPACE_NAME
-------------------------------------------------------------------------------- ------------------ ------------------------------
TEST123                                                                          TABLE              OOO
SYS_IL0000053986C00001$$                                                         LOBINDEX           OOO
SYS_LOB0000053986C00001$$                                                        LOBSEGMENT         OOO
 
SQL> select STATUS from dba_indexes where index_name='SYS_IL0000053986C00001$$';
 
STATUS
--------
VALID
 
最后是有效的不需要重建。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7728585/viewspace-702057/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7728585/viewspace-702057/