For over 10 years, since its introduction in Oracle8, partitioning has been a very powerful tool for management and performance of Oracle databases. Each major release since that time has added additional capabilities and Oracle Database 11g is no exception. Several powerful options are now available which allow for almost unlimited flexibility in building and managing partitioning. This presentation will discuss the new partitioning features introduced in Oracle Database 11g including interval, virtual column, reference, and system partitioning, and a range of additional composite partitioning options. Included will be a discussion of enhancements for single partition export and changes to the SQL Access Advisor. Examples will be shown along with usage recommendations for the new capabilities.
Enhanced Partitioning in Oracle Database 11g
