3 Replies Latest reply on Jan 29, 2013 3:37 PM by JustinCave

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

    User505978 - Oracle
      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