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
Read the full whitepaper
Premium Content: access is limited to Quest Corporate and Professional members.
Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.