| |
 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Partitioning
Data partitioning is an absolute requirement
for the administration and management of large database tables and
indexes. In Oracle, a partitioned table is divided into components
called tablespace partitions (see Figure 1). All table partitions
have the same logical attributes (columns, datatypes, and integrity
constraints). Oracle allows administrators to store each partition
in a separate tablespace. Separate tablespaces allow each partition
to have different physical storage characteristics (PCTFREE, PCTUSED,
PCTINCREASE etc.).
Figure 1: Partitioned tablespace.
Partitioning of data into separate tablespaces
provides the following advantages:
-
Increases availability - Data corruption is
less likely to occur across multiple tablespaces. If data does
become corrupted in a single, partitioned tablespace, all other
partitions are still available for queries and DML. In addition, you
can perform certain administrative operations against a single
tablespace partition. Once again, all other tablespace partitions
remain unaffected and are available for access.
-
Easier administration - Administrative
operations (import/export, analyze, backup/recovery and load) can be
performed on individual partitions. Remaining partitioned
tablespaces continue to be available for access.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
