This discussion is archived
2 Replies Latest reply: Jan 28, 2013 7:07 AM by 987245 RSS

Is it possible replicate data but ignore certain DML operations?

987245 Newbie
Currently Being Moderated
Hi everyone,

We are currently using a writable materialized view to perform data replication between our primary and secondary server. We are running into a problem because one of our tables gets updated quite a lot, and the materialized view refresh is at a point where it can't catch up with the updates (we're refreshing once every 30s, the refresh group takes anywhere from 9-22s to finish under load). After discussion with the server engineer we found that we really don't care about the updates on that particular table, only inserts and deletes. If we can just ignore synchronizing the updates that will be the perfect solution...

From my research, you really can't use materialized view to replicate data and only capture or ignore specific DML in Oracle 11.2. Am I correct here? Do we have to resort to a trigger/package-based manual replication strategy in order to only capture inserts/deletes without going to more advanced replication strategy (ex. use GoldenGate)?

Peter

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points