2019-11-08 21:43:10 WARNING OGG-00869 Oracle GoldenGate Delivery, <replicat>.prm: [SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]Timestamp parameters with a scale, must have a scale less than ten and a precision equal to 20 plus the scale. You specified a precision ...
process abend ogg 00869 ora 14402 通过OGG图形化软件发现OGG进程存在异常 通过ogg进程 GGSCI>view report ogg_process_name 检索error 报错信息发现ogg 00869 ora 14402 ORA-14402: updating partition key column would cause a partition change (status =14402), SQL <UPDATE <"SCHEMANAME">.<"TABLENAME"> SE...
看了表的属性后,追查到做了数据变更的源SQL语句,更新INVBALQTY 字段为0,当时猜想这里的0应该跟字段上属性default value 设置有关。 其实这是ogg 11R2 的CDR(Conflict Detection and Resolution,当前环境OGG的版本是11.2.0.1)参数设置问题导致的,加上参数NOCOMPRESSUPDATES,使当前更新的SQL完整捕获到列INVBALQTY的值。
Wish you can help me now,Thanks a lot. GGSCI (racdb1) 290> add trandata MOE_ODI.E$_XA_ZJ_YS 2013-07-04 12:04:21 WARNING OGG-00869 No unique key is defined for table 'E$_XA_ZJ_YS'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEY...
51CTO博客已为您找到关于ORA-01407 OGG-00869 的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及ORA-01407 OGG-00869 问答内容。更多ORA-01407 OGG-00869 相关解答可以来51CTO博客参与分享和学习,帮助广大IT技术人实现成长和进步。