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