DDL Replication Limitation

DDL replication is not certified with Replication Agent for Oracle 15.7.1 SP120 version when you use XStream APIs to read from Oracle database logs.

Unsupported DDL Configuration Parameters

DDL replication configuration parameters that are not supported.
Parameter Description
pdb_auto_alter_repdefs

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

pdb_automark_tables

Determines whether Replication Agent automatically marks tables for replication during DDL replication.

lr_send_trunc_partition_ddl

Determines whether truncate partition commands are sent as DDL or DML to the replicate database.

ddl_password

Updates the log device repository in the RASD. Identifies the password for ddl_username.

ddl_username

The database user name included in Log Transfer Language (LTL) for replicating DDL commands to the standby database. This user must have permission to execute all replicated DDL commands at the standby database.

Unsupported DDL Commands

DDL replication command that is not supported.

pdb_setrepddl – returns DDL replication status, and enables or disables replication for DDL statements.

See the Replication Agent Reference Manual for command and configuration parameters information.