8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Partitioning Enhancements in Oracle Database 12c Release 1 (12.1)
This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 1.
- Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION in Oracle Database 12c Release 1
- Asynchronous Global Index Maintenance for DROP and TRUNCATE Partition in Oracle Database 12c Release 1
- Interval-Reference Partitioning in Oracle Database 12c Release 1
- Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1
- Partial Indexes for Partitioned Tables in Oracle Database 12c Release 1
- Partition Maintenance Operations on Multiple Partitions in Oracle Database 12c Release 1
- Statistics Collection Enhancements in Oracle Database 12c Release 1 : Enhancements to Incremental Statistics
- Extended Composite Partitioning
Extended Composite Partitioning
Composite partitioning has been extended to include hash-* partitioning. The available composite partitioning schemes are listed below.
- Range-Range (8i)
- Range-Hash (8i)
- Range-List (9i)
- List-Range (11gR1)
- List-Hash (11gR1)
- List-List (11gR1)
- Hash-Hash (12cR1)
- Hash-List (12cR1)
- Hash-Range (12cR1)
Related articles.
Hope this helps. Regards Tim...