ITPub博客

首页 > Linux操作系统 > Linux操作系统 > (转)ORA-10631: SHRINK clause should not be specified for this object

(转)ORA-10631: SHRINK clause should not be specified for this object

原创 Linux操作系统 作者:monica_yaotf 时间:2012-02-03 11:53:31 0 删除 编辑
SQL> create index i_upper_e on t_shrink(upper(e));
 
Index created
 
SQL> alter table t_shrink enable row movement;
 
Table altered
 
SQL> alter table t_shrink shrink space;
 
alter table t_shrink shrink space
 
ORA-10631: SHRINK clause should not be specified for this object
 
SQL> drop index i_upper_e;
 
Index dropped
 
SQL> alter table t_shrink shrink space;
 
Table altered

 

 

查了一下官方文档,发现shrink这个操作有一些限制

Shrink operations can be performed only on segments in locally managed tablespaces
with automatic segment space management (ASSM). Within an ASSM tablespace, all
segment types are eligible for online segment shrink except these:
■ IOT mapping tables
■ Tables with rowid based materialized views
■ Tables with function-based indexes       --看来函数索引也不是那么容易用的
■ SECUREFILE LOBs
■ Compressed tables

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

请登录后发表评论 登录
全部评论

注册时间:2008-03-27

  • 博文量
    73
  • 访问量
    292874