Add DDL Replication

Configure DDL Replication for Oracle Golden Gate


sqlplus sys/password as sysdba


SQL> @marker_setup.sql


SQL> @ddl_setup.sql

SQL> @role_setup.sql

SQL> grant ggs_ggsuser_role to OGG_USER;

SQL> @ddl_enable;

SQL> @ddl_pin OGG_USER;


Configure Extract

DDL INCLUDE MAPPED
ddl options addtrandata
table andrey.*;


Configure replicat

DDLERROR DEFAULT IGNORE