Golden Gate Passthru A Journey of Exploration and Discovery

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release. ... PASSTHRU. RMTHOST oelgg2, MGRPORT ... ... PASSTHRU UserID ggadmin@TROY, Password ggadmin DDL INCLUDE ALL DDLERROR DEFAULT IGNORE map INFRA.*, target INFRA.*; SQLEXEC "begin dbms_ddl ... don't let me pass through this golden gate without you 'cause I can't carry back the things I want to bring you bokomolech. PASSTHRU RMTHOST 192.168.104.34, MGRPORT 7809. RMTTRAIL ./dirdat/RT CHECKPOINTSECS 1. TABLE ggtest.*;. Note that the extract is still stopped ... Using PASSTHRU improves performance by allowing GoldenGate to bypass looking up any table definitions from the database or the data-definitions ... 'COLCHARSET(PASSTHRU,*'), which does not convert text, has been substantially reduced for Oracle GoldenGate supported character sets. Security Options AES ... ... pass through the Golden Gate of the Ecliptic. Since the Moon is the closest of these heavenly bodies to the Earth and it is inclined at a high enough angle ... extract pump passthru rmthost Server\#B_IP, mgrport 31000 rmttrail /u01/app/goldengate/trail table test.sample1;. Setup Data Pump. GGSCI>add ... Example of Data Pump parameter file: EXTRACT PMP PASSTHRU RMTHOST 172.15.10.10, MGRPORT 15000, COMPRESS RMTTRAIL ./dirdat/rt. TABLE SCOTT.*;. Start/Stop the ... ... PASSTHRU|NOPASSTHRU ASSUMETARGETDEFS|NOASSUMETARGETDEFS 4. To check information related to parameters in parameter files use info param ...