Goldengate is the best tool for synchronizing data from heterogeneous databases. Add extract process ---- Extract parameter file to capture -- EXTRACT EIEX_EFSETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8") SETENV (ORACLE_SID = erpdb) userid system @ erpdb, PASSWORD erpadminTRANLOGOPTIONS asmuser sys @ ASM, ASMPASSWORD oracleEXTTRAIL. /dirdat/efTABLE erp_f. *; after TABLEEXCLUDE Delimiter is modified ---- Extract parameter file to capture -- EXTRACT delimiter (NLS_LANG = "delimiter") SETENV (ORACLE_SID = erpdb) userid system @ erpdb, PASSWORD erpadminTRANLOGOPTIONS asmuser sys @ ASM, ASMPASSWORD oracleEXTTRAIL. /dirdat/ef TABLE partition; TABLE erp_f.t00f0041; TABLE erp_f.t00f0042; TABLE partition; target end replicat repdmsetenv (NLS_LANG = "inline") SETENV (ORACLE_SID = erpdb) handlecollisionsSOURCEDEFS/oracle/GGfromdb2/dirdef/tbdm. defUSERID erp_k @ erpdb, PASSWORD kpreMAP db. tbdm01, TARGET erp_k.T00kn002, reperror (1403, ignore); MAP db. tbdm02, TARGET erp_k.T00kn006, reperror (1403, ignore );