17,377
社区成员
发帖
与我相关
我的任务
分享
...全文
请发表友善的回复…
发表回复
Dave 2009-12-08
- 打赏
- 举报
索引失效. 如果是为了解决高水位的问题，也可以尝试shrink table.
Oracle 10g Shrink Table 详解
http://blog.csdn.net/tianlesoftware/archive/2009/11/03/4764254.aspx
------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群：62697716
wh62592855 2009-12-07
- 打赏
- 举报
Restrictions on Moving Tables
这个不太清楚
给你列出一些限制吧
呵呵
Moving tables is subject to the following restrictions:
•If you specify MOVE, then it must be the first clause in the ALTER TABLE statement, and the only clauses outside this clause that are allowed are the physical_attributes_clause, the parallel_clause, and the LOB_storage_clause.
•You cannot move a table containing a LONG or LONG RAW column.
•You cannot MOVE an entire partitioned table (either heap or index organized). You must move individual partitions or subpartitions.
这个不太清楚
给你列出一些限制吧
呵呵
Moving tables is subject to the following restrictions:
•If you specify MOVE, then it must be the first clause in the ALTER TABLE statement, and the only clauses outside this clause that are allowed are the physical_attributes_clause, the parallel_clause, and the LOB_storage_clause.
•You cannot move a table containing a LONG or LONG RAW column.
•You cannot MOVE an entire partitioned table (either heap or index organized). You must move individual partitions or subpartitions.
