ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 关于重建LOB字段的表后是否需要重建LOB索引(试验)

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

原创 Linux操作系统 作者:gaopengtttt 时间:2011-07-13 11:07:25 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
wxh gp_22389860 <<深入理解MySQL主从原理专栏>> 发布 可加WX了解

注册时间:2008-10-13

  • 博文量
    739
  • 访问量
    3140276