Purge DDL tables in GoldenGate for multiple instances

When setting up a DDL replication in Integrated Capture there are couple tables that gets populated on a regular basis, Oracle provides a purge process that one can add to the manager parameter file and it will purge as configured. e.g: userid ogg, password xxxx PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30 PURGEMARKERHISTORY MINKEEPDAYS 3,…

Script to add trandata for GoldenGate

Here is a simple script to check which tables are missing trandata and generate the GG (so call DDL) to enable it on them. select ‘add trandata ‘||t.owner||’.’||t.table_name stmt from (select owner, table_name from dba_tables) t, (select owner, table_name from dba_log_groups) s where t.owner = s.owner (+) and t.table_name = s.table_name (+) and s.table_name is…

GGSCI Commands

Commands ggsci> HELP [command] [object] ggsci> help GGSCI Command Summary: Object:          Command: SUBDIRS          CREATE ER                   INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP EXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND, START, STATS,…