ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 10g__alter table shrink space compact

oracle 10g__alter table shrink space compact

原创 Linux操作系统 作者:wisdomone1 时间:2009-07-24 03:06:01 0 删除 编辑

压缩或缩小表的空间时,先要

alter table v4 enable row movement;

alter table v4 shrink space  compact;

 

shrink 语句的相当注意限制:

Restrictions on the shrink_clause The shrink_clause is subject to the following restrictions:

  • You cannot specify this clause for a cluster, a clustered table, or any object with a LONG column.

  • Segment shrink is not supported for tables with function-based indexes or bitmap join indexes.

  • This clause does not shrink mapping tables of index-organized tables, even if you specify CASCADE.

  • You cannot specify this clause for a compressed table.

  • You cannot shrink a table that is the master table of an ON COMMIT materialized view. Rowid materialized views must be rebuilt after the shrink operation.

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

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb qq: 305076427 微博: wisdomone9

注册时间:2008-04-04

  • 博文量
    2164
  • 访问量
    11762416