Partitioning tutorial - new features in Oracle Database 12c
- by KLaker
For data warehousing projects Oracle Partitioning really is a must-have feature because it delivers so many important benefits such as:
Dramatically improves query performance and speeds up database maintenance operations
Lowers costs by enabling a tiered storage approach that allows data to be stored on the most cost-effective storage for better resource utilisation
Combined with Oracle Advanced Compression, it provides an automated approach to information lifecycle management using a simple, efficient, yet powerful way to manage data growth and reduce complexity and costs
To help you get the most from partitioning we have released a new tutorial that covers the 12c new features. Topics include how to:
Use Interval Reference Partitioning
Perform Cascading TRUNCATE and EXCHANGE Operations
Move Partitions Online
Maintain Multiple Partitions
Maintain Global Indexes Asynchronously
Use Partial Indexes
For more information about this tutorial follow this link to the Oracle Learning Library: http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:8408,2 where you can begin your tutorial right now!
For more information about Oracle Partitioning visit our home page on OTN: http://www.oracle.com/technetwork/database/bi-datawarehousing/dbbi-tech-info-part-100980.html
