GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Filter not take effect

We have replicate OGG 12.3 and DB Oracle 12.1.0.2 , The belwo fillter not take effect

REPLICAT rephuat

SETENV (ORACLE_HOME = '/oraivr/app/oracle/product/12.1.0/dbhome_1')

SETENV (TNS_ADMIN = '/oraivr/app/oracle/product/12.1.0/dbhome_1/network/admin')

--- SETENV (ORACLE_SID="pgsit2")

USERID ogg_admin@pgsit, PASSWORD oracle

---SETENV (ORACLE_SID="PGNCSIT2")

--- USERID ogg_admin@PGNCSIT2, PASSWORD oracle

---- SOURCECHARSET PASSTHRU

MAP CISADM.HAYAT_ONLINE_STG, TARGET ogg_admin.HAYAT_ONLINE_STG, where (CIS_DIVISION <> 'TCBU' or CIS_DIVISION <> 'MCBU' or CIS_DIVISION=@NULL);

MAP CISADM.test, target ogg_admin.test;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center