RE: Replication question

Thanks Yechiel

     My apologies, I didn't make myself clear. I was thinking more along the lines of "if a table can be updated at multiple locations, how do I keep those updates from stepping on each other". For example, you could add an additional column named "location". Now each site has their own records. If that won't work for some tables, you might add a column "update_time". Now you can set a conflict resolution rule that the "last update wins". Maybe I should rephrase my question:

     Is there a list of potential schema changes, with whatever replication tool, that I can show this developer so he can see what work is ahead of him?     

Also, I was intrigued by your comment that Oracle Advanced Replication would use fewer resources (than standard replication, I assume). I have not heard this before, can you elaborate? Thanks

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, June 19, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L

Hello Dennis

The only schema changes you need for advance replication is primary key for each table (not a must but preferable).

Quest product, Shareplex, also prefer primary keys. According to Quest (not tested yet) their product use a lot less resources on the source system because AR is implemented via triggers.

The use of stand by against AR is the use of the second database. If you want to use it for queries or even update you need advance replication.
Also, I think that AR will send a lot less data through the network and the same for Quest Shareplex.

Synchronous Vs asynchronous depends on the need for two phase commit or you can live with a slight lag. It also depends on the network. Also, from the docs, asynchronous use more resources in the source system, as it writes the updates to an oracle table, reads them, send them across and then delete them from the tables.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, June 14, 2002 4:58 PM

> We are just starting to look at replication so each manufacturing plant
can
> have their own server. The applications are being developed in-house. I
feel
> the first issue is to analyze each table and decide how it will be
> replicated and what schema changes need to me made to accommodate
> replication. Instead, one of the developers wants to talk to Quest about
> their solution. It seems to me that you need to make the same evaluation
and
> schema changes where needed. If anyone can point me to a white paper on
> schema changes to consider, that would be appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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: Yechiel Adar
  INET: adar76_at_inter.net.il

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).