1 2 Previous Next 19 Replies Latest reply: May 11, 2012 3:44 AM by 936683 RSS

    Streams without a database link

    brum
      We have 2 databases on separate networks and there is zero possibility of them ever being able to talk to each other. However, the data in most (not all) of the schema objects should be the same. Right now, we are using our UTL app on each system to process the same feeder files twice. This has posed many problems that I won't go into here.

      We could do a data pump exp/imp of the objects and burn that to a DVD. This is a lot of work and not reasonable to do on a daily basis. Also, the changed data is all we care about but what I've read of streams is that database links are required for all types of streams.

      Does anyone have any input or ideas on how we can move the changed data between two databases that can not and will not ever be on the same network?

      Please let me know if you need me to clarify or explain more...
        1 2 Previous Next