Replication Agent 15.5 introduces support for replication of the ANYDATA datatype in an Oracle-to-Oracle replication system. ANYDATA, which can be used as a table column datatype, lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types.
The ANYDATA datatype is supported only when the primary database and the replicate database are both Oracle, and when the primary table and replicate table have the same column, which is ANYDATA.
A new configuration parameter, pdb_ignore_unsupported_anydata has been introduced to support the ANYDATA datatype. This parameter determines whether Replication Agent should ignore data for unsupported datatypes stored in ANYDATA columns or should send illegal data. If set to true, the unsupported data in the ANYDATA is not replicated to the replicate side. If set to false, illegal data is replicated, causing Replication Server to fail, thus allowing intervention or correction to take place in Replication Server or the replicate database, for each row containing unsupported data. See the Replication Agent 15.5 Reference Manual.
Replication Agent does not extend support for ANYDATA when:
Replication is from an ANYDATA column to a non-ANYDATA column.
ANYDATA size exceeds 16KB, which is the size constraint of the Replication Server OPAQUE datatype.
BFile, UROWID, REF, NESTED TABLE, and VARRAY datatypes are stored in the ANYDATA column.
See Chapter 1, “Replication Agent for Oracle,” in the Replication Agent 15.5 Primary Database Guide.