| 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: Oracle Replication Product
Hi
All my databases are in Oracle. I have been using Multi Master Oracle Replication.
I agree there are some constraints with Oracle Replicator. For everything there is some workaround methods are there.
But i feel it is reasonable. I donot know about sybase and other replicators.
So ican't compare the pros and cons among the replicators.
I would also like to know ur experinces with Oracle Replicator and others as well.
Thanks & Regards
From: Shawn.Ferris_at_twtelecom.com on 16/11/2000 04:40 GMT
Please respond to ORACLE-L_at_fatcity.com
To: ORACLE-L_at_fatcity.com
cc:
Subject: RE: Oracle Replication Product
Including this one.. 8) (Well almost anyway)
However, I was lead to believe Sybase's replication on Oracle was superior due to the fact that it read from the logs. (I'd never used it and since it wasn't originally a Sybase product, it sounded reasonable.)
In the same argument, they say Oracle's replication sucks because it's trigger based.
Let it be known that Sybase replication "SIMULATES" Sybase transaction logs in Oracle via, none other than, TRIGGERS! 8)
In a heterogeneous environment, I'd say Sybase replication. If it's just Oracle, I'd say stay native. Less overhead.. Of course, that being said from a DBA that's never used Oracle's replication either! 8)
$.02
Shawn M Ferris
Oracle DBA - Time Warner Telecom
> -----Original Message-----
> From: Jared Still [mailto:jkstill_at_bcbso.com]
> Sent: Wednesday, November 15, 2000 3:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle Replication Product
>
>
> On Tue, 14 Nov 2000, oradba guess wrote:
>
> > Hi,
> > I am in the process of evaluating prodcuts for replication of
> > data in Oracle database environment. I know Oracle Replcation
> > is the worst of all. I am trying to find out what are the
> > 3rd party products I should look into.
> >
> > Please share any experience you have.
> >
> > thanks,
> >
>
> Quest has a product, check it out at quest.com
>
> Sybase' replication server is an excellent product and
> will replicate Oracle databases. They've sold quite a
> few to Oracle shops.
>
> Jared
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shawn Ferris INET: Shawn.Ferris_at_twtelecom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Wed Nov 15 2000 - 23:57:57 CST
 |
 |