Dennis
The changes in 4 tables would be on server1 and cnages in 3 tables would be
on server2.please suggest how to do this if possible.
thx
-Seema
>From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 14:43:25 -0800
>
>Seema -
> I have only done just a little testing of replication, so I'm hardly
>the expert. I believe the answer to your question is yes. You can make db1
>the master site for the 4 tables and db2 the master site for the 3 tables.
> The bigger question is whether changes can be made to these tables
>from either side. If the answer is no, then simple snapshots will be
>sufficient. If the answer is yes, then you must look at how the application
>is designed. Can you make changes to the application to avoid problems in
>replication?
> But people tend to approach replication with a set of ideas and then
>find that they must change those ideas as they learn more. Oracle
>Replication is not a high-volume method, so you must have a good handle on
>how many rows will get changed each day.
> A good book is "Oracle Distributed Systems" by Charles Dye.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>
>-----Original Message-----
>Sent: Friday, April 19, 2002 4:59 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Dennis
>I want to do sync 4 tables from db1 to db2 and 3tables from db2 to db1.
>If i make one server as master server then is it possible to make secondary
>server(snapshot server) once and vice versa.
>Thanks
>-Seema
>
>
> >From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: REPLICATION/FAIL OVER
> >Date: Fri, 19 Apr 2002 13:09:19 -0800
> >
> >Seema - Advanced replication is a feature of Oracle Enterprise Edition,
>so
> >if you have that, you should be set. Based on your description, updatable
> >snapshots may meet your needs, and be simpler to configure and maintain.
> >Dennis Williams
> >DBA
> >Lifetouch, Inc.
> >dwilliams_at_lifetouch.com
> >
> >
> >-----Original Message-----
> >Sent: Friday, April 19, 2002 3:49 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Is there any additional software required if i go to advanced
>replication?
> >-seema
> >
> >
> >
> > >From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: RE: REPLICATION/FAIL OVER
> > >Date: Fri, 19 Apr 2002 10:03:57 -0800
> > >
> > >Seema - You could buy a separate replication package to do this, but
>you
> > >probably couldn't justify the cost.
> > > You could simply write some scripts to do this. But if you use
> > >Oracle's Basic Replication, then you get some resume material as a
>bonus.
> > >Dennis Williams
> > >DBA
> > >Lifetouch, Inc.
> > >dwilliams_at_lifetouch.com
> > >
> > >
> > >-----Original Message-----
> > >Sent: Friday, April 19, 2002 12:40 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >Hi
> > >I want to do sync two database once in a day.I have one database named
> > >test1
> > >
> > >on one server and another db named test2 on other server.I want to sync
> >10
> > >tables from db test1 to db test2 and 20 tables from db test2 to db
>test1.
> > >How can I do this?Is is only way to go replication?IS any other way to
>do
> > >that?If I go replication then can someone suggest which replication
> >method
> > >would be good.
> > >Thx
> > >-Seema
> > >
> > >
> > >_________________________________________________________________
> > >Chat with friends online, try MSN Messenger: http://messenger.msn.com
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Seema Singh
> > > INET: oracledbam_at_hotmail.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: 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).
> >
> >
> >
> >
> >_________________________________________________________________
> >MSN Photos is the easiest way to share and print your photos:
> >http://photos.msn.com/support/worldwide.aspx
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Seema Singh
> > INET: oracledbam_at_hotmail.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: 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).
>
>
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
> INET: oracledbam_at_hotmail.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: 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).
Send and receive Hotmail on your mobile device:
http://mobile.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: oracledbam_at_hotmail.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).
Received on Sat Apr 20 2002 - 03:33:18 CDT
