pdb_auto_alter_repdefs

(Oracle only) Determines whether Replication Agent automatically generates alter replication definition statements when processing changes in a marked table schema.

Note: This parameter is available only for Oracle.

Default

false

Values

true – Replication Agent automatically generates alter replication definition statements when processing changes in a marked table schema.

false – Replication agent does not automatically generate alter replication definition statements when processing changes in a marked table schema.

Comments

  • Replication Agent for Oracle automatically generates the alter replication definition command if you:
    • Create or drop a unique index.
    • Add, drop, or modify columns in a marked table.
  • Replication Agent for Oracle does not generate the alter replication definition command if you:
    • Combine two different operations into a single one. For example, add column and drop column using a single alter table DDL statement.
    • Drop all primary key columns using a DDL statement.
    • Rename a table or a column.
    • Perform any other change that is not listed in the first bulleted item in the Comments section.
  • Sybase recommends that you enable pdb_auto_alter_repdefs during DDL replication. If DDL replication is disabled and pdb_auto_alter_repdefs is enabled, replication might fail due to unsynchronized table schema between primary and replicate databases.
  • The pdb_auto_alter_repdefs parameter is valid only when Replication Agent for Oracle is in the Replicating state and processing the alter table DDL statement in a marked table.