ORA-10631: SHRINK clause should not be specified for this object
来源:互联网 发布:免费网络存储 编辑:程序博客网 时间:2024/06/05 18:43
ORA-10631: SHRINK clause should not be specified for this object
查询得知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
老外说的太别扭,个人翻译如下:
Shrink 操作需满足表空间是本地管理和自动段空间管理(10g、11g默认就是这样),以下情况不能用shrink:
IOT索引组织表
用rowid创建的物化视图的基表
带有函数索引的表
SECUREFILE 大对象
压缩表
检查traderecode的索引果然有函数索引,所以导致报了ORA-10631错误。
近来发现oracle的新特性总是有些局限或缺陷,例如今天碰上的Shrink,以上就是它的缺陷。
相比alter table move,Shrink的进步是:
1.可在线执行
2.可使用参数cascade,同时收缩表上的索引
3.执行后不会导致索引失效
4.可避免alter table move执行过程中占用很多变空间(如果表10G大小,那alter table move差不多还得需要10G空间才能执行)。
- ORA-10631: SHRINK clause should not be specified for this object
- ORA-10631: SHRINK clause should not be specified for this object
- ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
- IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
- IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
- ORA-13504: No SYSAUX datafile clause specified
- ORA-13504: No SYSAUX datafile clause specified
- ORA-14185: incorrect physical attribute specified for this index partition
- INS-32026]The Software Location specified should not be under Oracle base location.
- throwable should not be caught
- Why you should not shrink your data files
- ORA-14099 : all rows in table do not qualify for specified partition & ORA-14126
- the specified license key not be verified as belonging to this host
- ORA-31623: a job is not attached to this session via the specified handle
- ORA-02096: specified initialization parameter is not modifiable with this option
- ORA-31623: a job is not attached to this session via the specified handle
- ORA-01438处理方法 value larger than specified precision allowed for this column
- ORA-01438: value larger than specified precision allowed for this column
- 添加tslib到directfb
- 在页面中调用skype
- 《你必须知道的495个C语言问题》知识笔记及补充
- 原生Camera设置的分析(一):布局
- MySQL在大型网站的应用架构演变
- ORA-10631: SHRINK clause should not be specified for this object
- 黑马程序员-OC笔记(四)核心语法
- 公司需要内部的地图服务,准备自己去开发但是成本太高,现在有没有专门为企业提供GIS地图开发的产品呀?大概价格多少?
- MFC 多线程及线程同步
- 关注zigbee(二)
- IOS调试技巧:当程序崩溃的时候怎么办 iphone IOS
- wtregtry
- No.01 Xcode(5.1.x) 在Vmware中安装Mac OS X 10.8
- MySQL随机取一条数据 取指定条数的数据