oracle 10g__alter table shrink space compact

wisdomone1發表於2009-07-24

壓縮或縮小表的空間時,先要

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章