压缩或缩小表的空间时,先要
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-610133/