Oracle Corporation
Database partition management system

Abstract:

RI/ORASE history and current transaction data are stored in partitioned fact tables and aggregation tables based on business calendar. Most of associated indexes are locally partitioned indexes. In a typical RI customer environment, partitioned transaction data takes 85% or more of overall RI database space. The benefits of partitioning include easy management of data, enhanced performance, and assistance with backup and recovery. A partition management system provides the ability to create initial partitions and manage existing partitions in ways that allow the size of the partitioned database to exceed a backup limit size.