- Are total process records = inserts + updates + deletes +discards + ignores? Generally total process records = inserts + updates + deletes +discards + ignores - Are update collisions is part of updates ? Yes - Are delete collisions is part of deletes? Yes - Are total successfully process records = inserts + updates + deletes? Yes - Can HANDLECOLLISIONS handle ORA-00001 error? No, HANDLECOLLISIONS can not handle ORA-00001 error. This error is an unique constraint violation error. HANDLECOLLISIONS control whether or not replicate tries to resolve duplicate-record and missing-record errors when applying SQL on the target. These errors can occur during an initial load, when data from source tables is being loaded to target tables while Oracle Golden Gate is replicating transactional changes that are being made to those tables. You can read more about HANDLECOLLISIONS and NOHANDLECOLLISIONS in Oracle
How to understand goldengate report file statistics
原创maclean_007 ©著作权
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
How to understand decrator
High level function & Nested function:What is function:def name(): print('I am Blake')
decrator understand decrator