SHRINK SPACE CHECK
来源:互联网 发布:手机淘宝联盟怎么注册 编辑:程序博客网 时间:2024/06/05 07:59
利用SHRINK SPACE可以更好的对segment进行管理。但SHRINK SPACE功能在oracle的不同版本中也略有差异。
其实我们可以不用记住不同版本中SHRINK SPACE的限制条件。
因为oracle提供了‘ALTER TABLE ... SHRINK SPACE CHECK’的功能。
参考:What is the Meaning of SHRINK SPACE CHECK? [ID 1132163.1]
The "ALTER TABLE ... SHRINK SPACE CHECK" statement is used to to properly check for proper
segment type and segment attributes (e.g. row movement enabled) to allow shrink.
The statement performs the exact same verifications as the "ALTER TABLE ... SHRINK SPACE",
but it does not perform any actual shrinking on the segment.
用法:
SQL> alter table dept shrink space check;
alter table dept shrink space check
*
第 1 行出现错误:
ORA-10636: ROW MOVEMENT is not enabled
SQL> alter table dept enable row movement;
表已更改。
SQL> alter table dept shrink space check;
alter table dept shrink space check
*
第 1 行出现错误:
ORA-10655: Segment can be shrunk
这其实不是个错误,而是告诉我们这个段可以进行shrink操作。
This is not an error message, but rather a confirmation message about the possibility of shrinking the segment
关于SEGMENT SHRINK在ORACLE不同版本中的限制条件:
参考:SEGMENT SHRINK and details. [ID 242090.1]
Restrictions on the shrink_clause, 10gR1
========================================
1. You cannot specify this clause for a cluster, a clustered table, or any
object with a LONG column.
2. Segment shrink is not supported for LOB segments even if CASCADE is
specified.
3. Segment shrink is not supported for tables with function-based indexes.
4. This clause does not shrink mapping tables or overflow segments of
index-organized tables, even if you specify CASCADE.
5. 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.
6. Table with a domain index is not supported.
Restrictions on the shrink_clause, 10gR2
========================================
1. You cannot specify this clause for a cluster, a clustered table, or any
object with a LONG column.
2. Segment shrink is not supported for tables with function-based indexes or
bitmap join indexes.
3. This clause does not shrink mapping tables of index-organized tables,
even if you specify CASCADE.
4. You cannot specify this clause for a compressed table.
5. 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.
6. Table with a domain index is not supported.
Restrictions on the shrink_clause, 11gR1
========================================
1. You cannot combine this clause with any other clauses in the same ALTER TABLE
statement.
2. You cannot specify this clause for a cluster, a clustered table, or any
object with a LONG column.
3. Segment shrink is not supported for tables with function-based indexes or
bitmap join indexes.
4. This clause does not shrink mapping tables of index-organized tables, even if
you specify CASCADE.
5. You cannot specify this clause for a compressed table.
6. 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.
- SHRINK SPACE CHECK
- shrink space
- shrink space cascade/compact
- shrink space报ora-10635
- 收缩表段(shrink space)
- 收缩表段(shrink space)
- 收缩表段(shrink space)
- OCP-043 SHRINK SPACE CASCADE
- shrink space产生大量日志
- 收缩表段(shrink space)
- 表收缩(shrink space)
- 收缩表段(shrink space)
- oracle shrink space 与move
- Shrink space合并表的碎片
- Shrink space合并表的碎片
- Shrink space合并表的碎片
- Shrink space合并表的碎片
- oracle shrink space的最佳实践
- 实现像飞鸽一样的文件传输功能
- Codeforces #77 Volleybal
- C# winform与 flash as 的交互通讯
- 宝宝来了
- 用JS获取表格单元中的数据
- SHRINK SPACE CHECK
- xml查询入门笔记
- C#鼠标自动点击
- Oracle的merge
- 项目总结:ORACLE通过JOB定时创建表的运用
- td定义了width:400px;但在页面里不起作用
- 数字摘要码
- 02-08 控制AutoCAD环境(八) 提示用户输入
- 合理规划您的硬盘分区