Goldengate複製程式錯誤Fatal error executing DDL

目標資料庫錯誤：

2011-02-28 14:19:39  ERROR   OGG-00519  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  Fatal error executing DDL replication: error [Error code [1435], ORA-01435: ?????, SQL ALTER SESSION SET CURRENT_SCHEMA=SWASBHOM ], no error handler present.

2011-02-28 14:19:39  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  PROCESS ABENDING.

 

解決：

在複製程式指令碼加上

DDL INCLUDE MAPPED

DDLERROR DEFAULT IGNORE RETRYOP

 

把程式修改成如下格式：

REPLICAT roraBB

userid userid  gg,password gg

HANDLECOLLISIONS

ASSUMETARGETDEFS

DISCARDFILE ./dirrpt/roraBB.DSC, PURGE,MAXBYTES 50000000

DDL INCLUDE MAPPED

DDLERROR DEFAULT IGNORE RETRYOP

MAP OWAS.*, TARGET OWAS.*;

MAPEXCLUDE OWAS.SYS_IMPORT_FULL_01, TARGET OWAS.SYS_IMPORT_FULL_01;

MAPEXCLUDE OWAS.SYS_EXPORT_SCHEMA_01, TARGET OWAS.SYS_EXPORT_SCHEMA_01;

 

然後重新啟動程式。