Partitioned Tables

Replication Agent supports Oracle partitioning functionality.

Partitioning allows a table, index, or index-organized table to be subdivided into smaller pieces, where each piece of such a database object is called a partition. Each partition has its own name and may optionally have its own storage characteristics. Any table can be partitioned into many separate partitions except those tables containing columns with LONG or LONG RAW datatypes.

Unstructured data (such as images and documents) stored in a LOB column in the database can also be partitioned. When a table is partitioned, all the columns reside in the tablespace for that partition, with the exception of LOB columns, which can be stored in their own tablespace. For additional information about Oracle partitioning, see the Oracle Database VLDB and Partitioning Guide at http://download.oracle.com/docs/cd/B28359_01/server.111/b32024/toc.htm.