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!

Data Replication Between Sqlserver and Oracle11g using materialized view.

Balaram kothaJul 18 2012 — edited Aug 13 2012

I have Sqlserver 2005 as my source and oracle11g as my target.I need to populate the target daily with change data from source.
for that we have created a dblink between sqlserver and oracle and replicated that table as a Materialized view in Oracle.
problem we are getting here is Fast refresh option is not available.each day it will pick full data from the source.
is there any way to use Fast refresh in this scenario??

Thanks in advance.

Regards,
Balaram.

This post has been answered by Mark Malakanov (user11181920) on Aug 13 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2012

Added on Jul 18 2012

#database, #database-key-features, #oracle, #replication

3 comments

2,679 views