RE: Replication question

Dennis,

        All dbs whether SQL Server or Oracle need to deal with conflict resolution, thats not strictly an Oracle limitation. As far a Quest goes, they handle replication completely different from Oracle. Oracle itself is still using triggers (in 8i at least) , ubt now they hide the trigger, Shareplex reads the Oracle redo logs. I believe that 9i uses the redo logs and is based (structured) after Shareplex itself - there were lots of articles on this with the pre-release of Dataguard. Furthermore, Oracle places all of its replication metadata in SYSTEM tablespace which I dont like, Sharpelex uses its own (which the user configures). As far as Shareplex manuals, Quest is the one company that I will stand up and say that regardless of anything else, their documention is EXCELLENT. Their documentation takes you from Shareplex architecture right to directory structure, actual files, usage and even scripting. The sales rep was incorrect. However, I can see them not releasing the manuals without a purchase.

        I believe that they are available on-line for download, though I do not know if it is just for current customers only. (hehe can't believe I am defending a vendor:>). But when someone does something right, I like to give credit. Also, once you are setup, they are VERY stable. I have my issues with them, but overall I feel they do great job at what they do.

Hannah - Hope it helps any.

> -----Original Message-----
> From: root_at_fatcity.com_at_SUNGARD On Behalf Of DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> Sent: Thursday, June 20, 2002 10:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Replication question
>
> Yechel - Wow, what a blow to be struck with the dreaded RTFM first thing in
> the morning. Thanks Yechiel, I needed that.
> Actually, I was hoping there was another resource besides the
> manual, for two reasons:
> 1. This development group is a little irritated that they are forced
> to use Oracle instead of MS SQL, so they are taking replication issues as
> being Oracle limitations.
> 2. They have been talking to the Quest salespeople, who naturally
> heap disdain on Oracle's standard replication (selected Oracle SE because
> the price was closer to MS SQL). I asked the Quest rep if they had a
> document similar to the Oracle manual. Gosh, he couldn't think of one. Since
> nobody on the list has mentioned one, maybe they don't have one. The best
> resource I've found so far is a former Sybase DBA who was able to confirm
> that log-based replication has most of the same issues as Oracle standard
> replication has.
> Thanks everyone for your replies.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: johanna.doran_at_sungard.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).