pdb_ignore_unsupported_anydata

(Oracle only) Determines whether Replication Agent ignores data of unsupported datatypes stored in columns of type ANYDATA.

Default

false

Values

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.

Comments

  • Replication Agent does not replicate data of these 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 takes effect once you re-mark 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 fails, 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. You can do this only 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. You can do this only 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.