Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle to MS SQL Server Data Replication using Oracle Streams 11gR2

3140942Dec 16 2015 — edited Feb 29 2016

I have setup Oracle streams data replication between an Oracle DB and MS SQL Server DB but I get the following error during the apply process following an insert into the source table in the Oracle DB:

"ORA-26711: Remote table does not contain a primary key constraint"

I don't understand why I am receiving this error as the remote table in MS SQL Server DB has a primary key. I have double checked my config/setup and all looks correct. It seems that the data replication is working fine up until the final write/commit in the remote table.

Has anyone had experience of this issue and knows how to resolve it?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2016

Added on Dec 16 2015

#performance-availability, #streams

3 comments

2,126 views