7 Replies Latest reply: May 16, 2012 6:49 AM by Rob_J RSS

    Oracle Streams without DB Link

      Hi All,

      We have a requirement to move data for approximately 20 tables from a database in a particular network to a database in another network. The database on both sides is running on 11g and has RAC implementation.

      For doing this replication following options are there

      - Oracle Streams
      - Oracle Golden Gate
      - Datapump Export and then Import

      We have the following restrictions for doing the transfer

      - No DB Links cannot be created
      - No additional licenses can be bought for buying Golden Gate

      With the above limitations can we still go with Oracle Streams (as I have read oracle documentation and it says DB Link is mandatory) or am I just left with the option of datapump

      Thanks in advance,