Oracle9i Partitioning Options
Oracle8 introduced table partitioning with a feature known as range partitioning. Range partitioning means separating the rows from a table into various predefined tablespaces by a key, known as the partition key. The table can be accessed like any other table by its table name, or each partition can be accessed individually. An example of this is a quarterly report on a particular quarter in which the table is partitioned by date so that a quarter's worth of data resides in each tablespace. This report, knowing that it was going to use only data from this one “quarterly” tablespace, could just access this one tablespace, saving the optimizer and Oracle some work.
Each tablespace can be backed up and restored independently ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
