For some IT demands it’s necessary to replicate DDL’s (Data Definition) to maintain source/target equalized.
So Oracle delivery excellent feature DDL Replication since GG 10G.
In GG 12c the procedure turns simplified.
So, under GoldenGate home, do SQLPLUS as sysdba:
SQL> @role_setup.sql GGS Role setup script Enter GoldenGate schema name:ggate Wrote file role_setup_set.txt PL/SQL procedure successfully completed. Role setup script complete Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command: GRANT GGS_GGSUSER_ROLE TO where is the user assigned to the GoldenGate processes. SQL> GRANT GGS_GGSUSER_ROLE TO ggate; Grant succeeded. SQL> @ddl_enable.sql Trigger altered.
Configure Extract/Pump/Replicat with DDL Replication:
Insert into those process parameter ” DDL INCLUDE MAPPED”
EXTRACT E_DBA USERID OGG PASSWORD OGGPASS EXTTRAIL ./dirdat/fo TRANLOGOPTIONS EXCLUDEUSER OGG DDL INCLUDE MAPPED TABLE OGG.*;