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 <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >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. >[EMAIL PROTECTED] > > >-----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 <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >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. > >[EMAIL PROTECTED] > > > > > >-----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 <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >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. > > >[EMAIL PROTECTED] > > > > > > > > >-----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: [EMAIL PROTECTED] > > > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).