Extents in Indexes (19)
All extents allocated to an index segment remain allocated as long as the index exists.
When you drop the index or associated table or cluster, Oracle reclaims the extents for
other uses within the tablespace.
只要索引存在 , 索引段還保留著 . 刪除了索引對應的table or cluster後 ,
索引段可供表空間內其他使用者使用.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-968505/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Overview of Indexes (194)ViewIndex
- Indexes and Nulls (198)IndexNull
- Unique and Nonunique Indexes (195)Index
- Composite Indexes (196)Index
- Indexes and Keys (197)Index
- Reverse Key Indexes (219)Index
- Function-Based Indexes (199)FunctionIndex
- Overview of Extents(11)View
- MSSQL---extentsSQL
- Oracle 19C 無法啟用Auto Indexes特性OracleIndex
- Rebuild IndexesRebuildIndex
- ORACLE INDEXESOracleIndex
- Oracle 19c Concepts(03)：Indexes and Index-Organized TablesOracleIndexZed
- How To Efficiently Drop A Table With Many Extents
- 為lob型別分配extents型別
- oracle中extents存在的理由Oracle
- Extents in Materialized Views and Their Logs (18)ZedView
- Oracle - Tables/IndexesOracleIndex
- Reverse Key IndexesIndex
- ORACLE -> NULL & INDEXESOracleNullIndex
- Overview of Partitioned IndexesViewIndex
- Local Partitioned IndexesIndex
- Global Nonpartitioned IndexesIndex
- [doc]How To Efficiently Drop A Table With Many Extents
- 翻譯（九）——Clustered Indexes: Stairway to SQL Server Indexes Level 3IndexAISQLServer
- skip_unusable_indexesIndex
- The Secrets of Oracle Bitmap IndexesOracleIndex
- Restrictions on Create Bitmap IndexesRESTIndex
- Global Range Partitioned IndexesIndex
- Global Hash Partitioned IndexesIndex
- Maintenance of Global Partitioned IndexesAINaNIndex
- JavaFX教程-廣度（Extents）和列舉Java
- Sparse Indexes vs unique indexIndex
- SKIP_UNUSABLE_INDEXES InitializationIndex
- Choosing Composite IndexesIndex
- 建立Function-Based IndexesFunctionIndex
- How Indexes Grow and PctfreeIndex
- Bitmap Indexes and Nulls (224)IndexNull