10 Replies Latest reply: Dec 17, 2013 8:29 PM by Hemant K Chitale RSS

    Replicate one table to another instance

    Felix_GG


      Hi specialists,

      i have a question, i have to replicate one oracle table to another instance.

      My setup is like this (Oracle 11g, 11.2.0.3):

       

      On Database 'Master', i have one table with about 200 inserts per second (no deletion, no updates, housekeeping by dropping a partition each month).

       

      For some reasons, i want to access this table on a other DB-Instance on a other Server, let's call it 'Slave'.

      So, i need a mechanism that replicates all inserts on 'Master' to 'Slave'.

      On the 'Slave-DB' will run special selects, so i need som indexes there.

       

      For financial reason, i don not want use GoldenGate.

       

      Is ther a simple mechanism to do this ?

      I thought about creating a trigger that is fired at each insert on 'Master' and does a insert to 'Slave' via a database-link, but

      maybe there are better solutions for this ?