oggformysqlddl_OGG执行DDL复制报ORA01435userdoesnotexist

OGG执行DDL复制报ORA-01435 user does not exist

2013-11-07 08:29:43 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep_app.prm: No unique key is defined for table &＃39;C&＃39;. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2013-11-07 08:29:43 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rep_app.prm: Fatal error executing DDL replication: error [Error code [1435], ORA-01435: user does not exist SQL ALTER SESSION SET CURRENT_SCHEMA&＃61;"UNID"], no error handler present.

2013-11-07 08:29:43 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_app.prm: PROCESS ABENDING.

报错用户UNID不存在&＃xff0c;但是我配置的意思只是想将UNIDDEV的DDL复制过去&＃xff0c;以下是我的replicat配置&＃xff1a;

REPLICAT rep_app

SETENV (NLS_LANG &＃61; "American_America.ZHS16GBK")

USERID goldengate,PASSWORD GOLDENGATE

REPORTCOUNT EVERY 30 MINUTES, RATE

REPERROR DEFAULT, ABEND

numfiles 5000

--HANDLECOLLISIONS

assumetargetdefs

DISCARDFILE ./dirrpt/rep_app.dsc, APPEND, MEGABYTES 1000

ALLOWNOOPUPDATES

map UNIDDEV.*, target UNIDDEV.*;

map SH.*, target SH.*;

GGSCI (JOADBTEST01) 7> view param ext_app

EXTRACT ext_app

setenv (NLS_LANG&＃61;AMERICAN_AMERICA.ZHS16GBK)

TRANLOGOPTIONS ASMUSER sys&＃64;asminst, asmpassword oracle

userid goldengate,password goldengate

REPORTCOUNT EVERY 1 MINUTES, RATE

numfiles 5000

DISCARDFILE ./dirrpt/ext_app.dsc,APPEND,MEGABYTES 1000

DISCARDROLLOVER AT 3:00

exttrail ./dirdat/r1,megabytes 100

dynamicresolution

TRANLOGOPTIONS EXCLUDEUSER goldengate

--TRANLOGOPTIONS convertucs2clobs

DDL INCLUDE ALL

TABLE UNIDDEV.*;

TABLE SH.*;

GGSCI (JOADBTEST01) 8> view param pmp_app

extract pmp_app

dynamicresolution

passthru

rmthost 10.0.15.107, mgrport 7839, compress

rmttrail ./dirdat/t1

numfiles 5000

TABLE UNIDDEV.*;

TABLE SH.*;

解决办法&＃xff1a;增加配置DDL INCLUDE。。。

本文原创发布php中文网&＃xff0c;转载请注明出处&＃xff0c;感谢您的尊重&＃xff01;