Skip to Main Content

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 streams做table 级别的同步Primary Key冲突问题

user2794132Mar 26 2018

我用streams做table级别同步时需要从source database里面2个table采集更新数据到target database的1个table里,但有可能存在Primary Key冲突问题,如何配置在insert 出现Primary Key冲突时改为update操作?

举例如下:

source database:

tab1( id number primary key, name varchar2(10));

tab2( id number primary key,  comments varchar2(10) );

target database:

tab3( id number primary key,  name varchar2(10),comments varchar2(10) );

我希望实现的效果是tab1或tab2新增一条记录时更新到tab3,tab3没有id相同的记录就insert,有id相同的就update,请问streams是否支持这种更新?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2018
Added on Mar 26 2018
0 comments
478 views