| 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: Replication Compatibility And Issues
Ray,
Potential vendors are Oracle (obviously) and Quest for SharePlex.
Oracle version 7 databases should be upgraded to at least 8i (8.1.7.4) ASAP. Oracle 9i thinks 7.x uses a foreign language.=20
One way, use Materialized views. Works fine.
Two way, get enterprise edition & advanced replication support, multi master. Works well. Setting it up the first time is confusing as all getout. After that it's easy. Shareplex isn't too much of a help here, it gets into an infinite loop.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Raj Gill [mailto:raju_gill_2003_at_yahoo.com]=20
Sent: Wednesday, October 13, 2004 12:01 PM
To: oracle-l_at_freelists.org
Subject: Replication Compatibility And Issues
Hi All,
=20
We have several Oracle databases with different versions i.e. Oracle 7.3.4, Oracle 8i and Oracle 9i. We need to keep data in sync between these databases. One way of achieving this is to use Oracle Replication.
=20
I need to find the answers to the following questions.=20
=20
=20
Venders
=20
One-Way
(Basic)
Two-Way
(Advance)
Hardware / Software / Bandwidth
Performance (# of trans, time, network traffic etc.)
Issues (performance, installation, admin, maintenance, interoperability etc.)
Interoperability
Pros/Cons
Oracle Replication
7.x - 9i
=20
=20
=20
=20
=20
=20
=20
Oracle Replication=20
7.x - 8.x
=20
=20
=20
=20
=20
=20
=20
Oracle Replication=20
8.x - 9i
=20
=20
=20
=20
=20
=20
=20
=20
=20
Does someone have any experience going through same situation?=20
=20
Can anyone direct me to the right source of information?
=20
Your help will be immensely appreciated.
=20
=20
Thanks
Raj
=09
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 13 2004 - 11:32:48 CDT
 |
 |