Supported Oracle Datatypes, Data, and Structures

Replication Agent supports the replication of encrypted data, compressed data, and SecureFiles.

Encrypted Data

Replication Agent transparently supports the replication of data in encrypted columns, partitions, and tablespaces for Oracle versions 11g Release 1 and later.

If your primary Oracle database version is earlier than 11g Release 1, you can still mark tables containing encrypted columns, partitions, and tablespaces using the force option, but the columns are not replicated.

Compressed Data

Replication Agent supports the replication of compressed tables, compressed tablespaces, and data compressed for Oracle direct-load operations (bypassing I/O buffers) for Oracle versions 11g Release 2 and later.

Note: If you want to replicate tables compressed for online transaction processing (OLTP), apply first the Oracle patch# 129050503.

SecureFile Data

Replication Agent supports the replication of Oracle data stored with the SecureFile option.

Replication Agent supports the replication of Oracle LOB data stored with the SecureFile option for Oracle versions 11g Release 2 and later. If your primary Oracle database version is earlier than 11g Release 2, you can still mark tables containing SecureFile LOB columns using the force option, but the columns are not replicated.