Data Partitioning

Large tables (and indexes) can create or magnify several problems in production database systems because of their size and storage characteristics. For example, consider the following scenarios :

A table becomes so large that associated management operations take longer to complete than the time window which is available.

• A query requires Oracle to complete a full table scan of a very large table. Application and system performance suffers which Oracle reads the numerous data blocks for the corresponding table.

• A mission-critical application depends primarily on a single large table. The table becomes unavailable when just a single data block in the table is inaccessible due to a disk failure. An administrator must recover the entire tablespace that contains the table before the table and corresponding mission- critical application can be brought back online.

To help reduce the typesof problems that large tables and indexes can create, Oracle8 supports partitioned tables and indexes.

Domain Name Search