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).
Received on Fri Apr 19 2002 - 16:58:31 CDT
