RE: Data Sync between Oracle8 and 9i or 10g
- To: <Shibu.MB@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Aug 2005 00:31:52 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of MB Shibu
Sent: Wednesday, August 24, 2005 2:13 AM
To: oracle-l@xxxxxxxxxxxxx
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 perform
Oracle 8 to 9i/10g data sync?
4)What are the most commonly used data sync tools ?
Regards
Shibu
************************************************************************
The information in this email is confidential and is intended solely
for the addressee(s).
Access to this email by anyone else is unauthorized. If you are not
an intended recipient, please notify the sender of this email
immediately. You should not copy, use or disseminate the
information contained in the email.
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Capco.
http://www.capco.com/
************************************************************************
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
