| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Sync between Oracle8 and 9i or 10g
What version of Oracle8 are you using? 8.1.7? 8.0.5?
Do you need to support both 9i and 10g on the other side? Or just one or the other? If you are using something earlier than 8.1.7, working with 10g is going to be significantly more challenging.
If you are talking about one-way replication and the Oracle versions are reasonably close (i.e. 8.1.7 on one side and 10.1 on the other) and you are thinking about something less than real-time or near-real time replication, you should be able to create a database link between the two machines, create a materialized view on the destination machine, and refresh that materialized view with the data from the source system. If you can go this route, this is going to be the easiest solution-- no need to resort to third party products when Oracle provides the functionality.
If you have a wider disparity of Oracle versions (i.e. you are running 8.0.4), if you need real-time or near real-time replication, you are likely to be in much worse shape.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of MB Shibu
Sent: Wednesday, August 24, 2005 2:13 AM
To: oracle-l_at_freelists.org
Subject: Data Sync between Oracle8 and 9i or 10g
Hi all,
I have one OLTP Oracle8 database server (Yess Oracle8 the de-supported one ) and want to synchronize that database with another Oracle Server (Oracle 9i or 10g) in a different location.
1)How can I sync data across oracle 8 and 9i/10g? 2)What are the options available to achieve data sync? 3)Is there any third party tools available in the market to performOracle 8 to 9i/10g data sync?
Regards
Shibu
 |
 |