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

数据库|mysql教程

ORA-01435,OGG执行DDL复制报ORA-01435

数据库-mysql教程

聚美post注册机源码,如何在vscode写java,ubuntu重启x,tomcat技术优势,python 爬虫 屏蔽,php怎么切换版本,浙江seo优化哪家有实力,92game网站源码,easyui 注册页面模板lzw

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

学生考勤系统php源码免费下载,ubuntu中g 指令,农村树林抓爬虫,php嵌入iframe,seo几种方式lzw

php仓库管理源码,vscode替换的快捷键,ubuntu缩小dock,tomcat端口绑定域名,爬虫批量抓取,settype php,公司官网有必要做seo,织梦关闭网站lzw

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

-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=”UNID”], no error handler present.

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

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

REPLICAT rep_app

SETENV (NLS_LANG = “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=AMERICAN_AMERICA.ZHS16GBK)

TRANLOGOPTIONS ASMUSER sys@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.*;

解决办法：增加配置DDL INCLUDE。。。

，