pdb_ignore_unsupported_anydata

Determines whether or not Replication Agent ignores data of unsupported datatypes stored in columns of type ANYDATA.

false

true – Replication Agent ignores data of unsupported datatypes stored in columns of type ANYDATA, sending no data for these columns to Replication Server.

false – Replication Agent sends the string type not supported to Replication Server for data of unsupported datatypes stored in columns of type ANYDATA. This causes Replication Server failure, after which corrections must be made at Replication Server or the replicate database for each table row containing unsupported data.

• Replication Agent does not replicate data of the following Oracle datatypes stored in a column of type ANYDATA:

  • BFILE

  • NESTED TABLE

  • REF

  • UROWID

  • VARRAY

• Replication Agent checks the setting of pdb_ignore_unsupported_anydata only when an object is marked for replication. To reset pdb_ignore_unsupported_anydata and change Replication Agent behavior for a marked object, you must unmark the object before you reset pdb_ignore_unsupported_anydata. The change to pdb_ignore_unsupported_anydata will take effect once you remark the object.

• If pdb_ignore_unsupported_anydata is set to true and the replicate table has a default column value for the corresponding ANYDATA columns, the primary and replicate tables will be inconsistent. If the replicate table has no default column value for the corresponding ANYDATA columns, Replication Server will fail, even though pdb_ignore_unsupported_anydata is set to true.

• To recover from a Replication Server failure caused by data of unsupported datatypes found in an ANYDATA column, do one of the following:

  • Alter the corresponding replicate table so that the table has a default value for columns of type ANYDATA. This can only be done if pdb_ignore_unsupported_anydata is set to true.

  • Create a trigger in the corresponding replicate table to provide a default value for columns of type ANYDATA. This can only be done if pdb_ignore_unsupported_anydata is set to true.

  • Customize a Replication Server function string to provide a default value for columns of type ANYDATA in the replicate table.