Oracle table Replication between versions

From: David Gempton <davidg_at_ttc4it_dot_co_dot_nz>
Date: Mon, 04 Aug 2008 12:02:36 +1200
Message-ID: <4896471d@clear.net.nz>

Can anyone suggest a way of Replicating a group of tables from one database out to another under these conditions:

+ Source database is version 8.1.7.4
+ Destination database is version is 10.2
+ Tables contain Longs
+ Tables do not have primary keys
+ Changes need to be applied to destination tables asap after the commit.

I've looked at Data Guard, Streams, & Snapshots, non of which fits the requirement.

Unfortunately upgrading the Source database is not an option for us due to the application being used.

Currently we are using a software solution that I specifically wrote to perform the task. But it has been suggested that there are better Oracle solutions. I am interested in using one of these if possible.

-- 

Kind regards
David Gempton - IT Consultant

Received on Sun Aug 03 2008 - 19:02:36 CDT

This message: [ Message body ]
Next message: Malcolm Dew-Jones: "Re: Options on session control in a web application"
Previous message: Ed Prochak: "Re: Options on session control in a web application"
Next in thread: fitzjarrell_at_cox.net: "Re: Oracle table Replication between versions"
Reply: fitzjarrell_at_cox.net: "Re: Oracle table Replication between versions"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message