Sais
I am takling about replication.The assumption is tables are having millions
of rows.In case if one Db server down i want to fail over to another one
also.Which option in replication would be good Is it Multimaster
replication.
Thx
-seema
>From: "Gene Sais" <Gsais_at_co.palm-beach.fl.us>
>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:08:50 -0800
>
>Now that depends on how big the tables are? A few options off the top of
>my head:
>
>1) Drop tables, export, import.
>2) Replication.
>3) Truncate, insert from select as.
>4) Spool data, sql*load it.
>
>so many ways to skin a cat...
>
>I would probably play w/ replication.
>
> >>> oracledbam_at_hotmail.com 04/19/02 01:39PM >>>
>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
>
>
>_________________________________________________________________
>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: Gene Sais
> INET: Gsais_at_co.palm-beach.fl.us
>
>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).
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).
Received on Fri Apr 19 2002 - 15:24:17 CDT
