Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g3HFjZl08931 for ; Wed, 17 Apr 2002 11:45:45 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA44292; Wed, 17 Apr 2002 08:48:49 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 00446A60; Wed, 17 Apr 2002 08:28:43 -0800 Message-ID: Date: Wed, 17 Apr 2002 08:28:43 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Reddy, Madhusudana" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Reddy, Madhusudana" Subject: RE: SYNC db 2 box Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit 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@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@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@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@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).