RE: Replication Compatibility And Issues
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <raju_gill_2003@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Oct 2004 12:37:11 -0400
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@xxxxxxxxx]=20
Sent: Wednesday, October 13, 2004 12:01 PM
To: oracle-l@xxxxxxxxxxxxx
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
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
