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