Replication Agent does not support the replication of data stored in ANYDATA columns under the following circumstances:
The replicate database table column is not of type ANYDATA. An attempt to replicate data stored in an ANYDATA column to a column that is not of the ANYDATA type will cause the Replication Server Data Server Interface (DSI) thread to fail.
The size of the data stored in an ANYDATA column exceeds the maximum size of the Replication Server opaque datatype, which is 16K.
Replication Agent does not replicate data of the following Oracle datatypes or structures stored in a column of type ANYDATA:
BFILE
Nested tables
REF
UROWID
VARRAY
The pdb_ignore_unsupported_anydata configuration parameter is provided to determines how Replication Agent handles data of unsupported datatypes stored in columns of type ANYDATA.
Replication Server will not perform character set conversion for character data stored in an ANYDATA column if the setting of the Replication Agent rs_charset configuration parameter is different from the setting of the Replication Server RS_charset configuration parameter.
Replication Server Reference Manual for information on replication definitions and the create replication definition command.
Oracle SQL Reference guide for a complete list of Oracle-supplied types.
Replication Agent Reference Manual for information on the pdb_ignore_unsupported_anydata configuration parameter.