(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.
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.