RE: SYNC db 2 box

From: Reddy, Madhusudana <Madhusudana.Reddy_at_bestbuy.com>
Date: Wed, 17 Apr 2002 08:28:43 -0800
Message-ID: <F001.00446A60.20020417082843@fatcity.com>

We have the almost similar thing like tables on the transaction server and tables on reporting server.

Created a snapshot group ( read only ) on the reporting server and updating them by scheduling a job which refreshes the jobs via dblink.

--Madhu

-----Original Message-----

Sent: Wednesday, April 17, 2002 10:14 AM To: Multiple recipients of list ORACLE-L

Hi
I have 2 databases running on 2 diffrent box and some of tables are commons on both the boxes.I want sync 20 tables on daily basis either 2 times in a day or once in a day.I am thinking that transportable tablespace feature with export/import would help in this.The another idea is replication.I would like to know which approach would be good.Let me know if any one have any great idea would be welcome.
Thank
-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: Reddy, Madhusudana
  INET: Madhusudana.Reddy_at_bestbuy.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 Wed Apr 17 2002 - 11:28:43 CDT