This discussion is archived
3 Replies Latest reply: Jan 29, 2013 7:37 AM by Justin Cave RSS

What is the best method for synchronizing tables in two different DB?

User505978 - Oracle Newbie
Currently Being Moderated
We have a core banking database and this database includes our customer related tables and these tables are really huge.

And we have other database for some applications and this database needs fresh customer data which take place in core banking database.


Our current method is materalized views but we have some performance problems about it.

What can give better performace for synchronizing the tables between databases?


-oracle streams?
-triggers?
-dbms_comparison?

or anything else?

Edited by: 983327 on Jan 28, 2013 2:14 PM

Legend

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