oracle 10g__alter table shrink space compact
壓縮或縮小表的空間時,先要
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] Shrink space & Table move比較Oracle
- oracle10g_alter table shrink space_compact_cascade回收空間測試(一)Oracle
- Oracle 10g Shrink Table - Shrink Space 收縮空間Oracle 10g
- Oracle OCP 1Z0 053 Q96(Shrink Space Compact)Oracle
- Oracle 11g alter table move與shrink spaceOracle
- ALTER TABLE MOVE | SHRINK SPACE區別
- ALTER TABLE MOVE和SHRINK SPACE區別
- Oracle IZ0-053 Q277(Table shrink space)Oracle
- oracle shrink tableOracle
- alter table move 和 alter table shrink space的區別
- alter table move 與shrink space的區別
- alter table move跟shrink space的區別
- 測試alter table shrink space compact cascade及學習user_tables相關列的含義
- alter table move跟shrink space的區別(轉)
- Oracle中shrink space命令詳解Oracle
- oracle10g shrink space 降低HWMOracle
- Oracle ASM Free Space TableOracleASM
- Oracle 10g Shrink Table 詳解Oracle 10g
- shrink space的最佳實踐
- Oracle中shrink space命令詳解[轉]--還示測試Oracle
- 7 、shrink table and its dependent segments
- table move 與 shrink 的區別
- oracle shrinkOracle
- How to adjust the high watermark in ORACLE 10g – ALTER TABLE SHRINKOracle 10g
- 頑固TABLEのtable-layout/white-space
- shrink space 的整個過程就是在做delete和insertdelete
- [重慶思莊每日技術分享]-在為表新增了列後執行ALTER TABLE SHRINK SPACE 提示ORA-8102
- How to Shrink Undo Segment In Oracle DatabaseOracleDatabase
- 壓縮table and index 對 space 的影響testIndex
- Oracle DBMS_SPACEOracle
- HOW TO SHRINK A TABLE USING ONLINE REDEFINITION (文件 ID 1357878.1)
- 轉載-oracle Shrink命令的使用Oracle
- SQL查詢table或index異常增長問題 - space_usage (show_space)SQLIndex
- Oralcle 10g資料庫做shrink space操作建立了大量redo日誌資料庫
- Oracle-Segment space managementOracle
- oracle 分割槽表進行shrink操作Oracle
- 【轉】Oracle:MOVE與SHRINK命令相比較Oracle
- 測試alter table storage及dbms_space_admin包