Home Dashboard Directory Help
Search

Oracle CDC by Attunity (SQL 2012) does not handle updated primary keys correctly by stefang_1234


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 774367
Opened: 12/14/2012 8:00:32 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

When a table has CDC enabled and the primary key is updated this should be treated as a delete followed by an insert. This is the behavior you get with SQL Server CDC, but Oracle CDC registers this as a normal update.

This problem makes it impossible to use cdc.fn_cdc_get_net_changes_<capture_instance> and MERGE to implement a simple replication.
Details
Sign in to post a comment.
Posted by TRyanSkinner on 7/18/2013 at 12:32 PM
Ping? It's been 6 months since the last comment. Any word on this?
Posted by Faiz VP on 1/21/2013 at 2:36 AM
I haven't started implementing it yet but can anyone else verify that this bug exists?
Sign in to post a workaround.