Saturday, October 19, 2013

Oracle 11g enhanced partitioning options

Reference partitioning
======================
allows you to equi-partition related tables in the same database, even if the columns are not present in all the child tables.

Interval partitioning
======================
embodies that highly desirable fire-and-forget power. You define an interval and Oracle takes care of the maintenance, forever.

Extended composite partitioning
===============================
The extension of composite partitioning to range-range, list-range, list-hash, and list-list exposes new possibilities for better partitioning choices and manageability.

Transportable partitions
=========================
Data Pump now allows you to transport and plug-in a single partition, a feature that is guaranteed to be quite useful in archival and retention.

Virtual column partitioning
============================
You can design the best possible partitioning strategy that mimics business flow by partitioning on virtual columns.

System Partitioning
===================
If a table lacks a column that is candidate for partitioning, the table can still be partitioned by using system partitioning,
where oracle will create as many partitions as you like.

The partitions must be explicitly referenced by the developers and users.

So instead of the statement:
insert into sales3 values (1,101,1);
you will have to use:
insert into sales3 partition (p1) values (1,101,1);

Source: Arup Nanda

No comments:

Post a Comment