From oracle-l-bounce@freelists.org Wed Jul 27 07:46:21 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6RCk6vQ001292 for ; Wed, 27 Jul 2005 07:46:16 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6RCjjIP001098 for ; Wed, 27 Jul 2005 07:45:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7F6F11D8CD1; Wed, 27 Jul 2005 07:45:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09100-02; Wed, 27 Jul 2005 07:45:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 051751D8CF6; Wed, 27 Jul 2005 07:45:25 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=KIkiOOhqifgVZeekmz49OuywD5a4EZHsnhnx8e7n16+EQ6o8221ngQ1dbyA5s9A+1DwIzGta3T0dpZV15fW6dEWU7EJjEnxdPyBEnb11DTR8jI68jiZseS+eSmYDBhJ5QaMa1EH0LjbqxWYyIzDXAg4/OEyAmHEQLWUzQeU9sIk= Message-ID: Date: Wed, 27 Jul 2005 08:43:37 -0400 From: Thomas Day To: VIVEK_SHARMA Subject: Re: DB Movement from Sun to AIX ? Cc: oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: X-archive-position: 22943 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tomday2@gmail.com Precedence: normal Reply-To: tomday2@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Yes. Read up on materialized views. Basically there is a job (or jobs) that run the refresh on a periodic basis. If the source database isn't available when the job runs then the next time the job runs (assuming the source database is available) then all the changes since the last successful job run are applied. You can do the refresh manually but it gets tedious very quickly. Much better to do it via a scheduled job. -- http://www.freelists.org/webpage/oracle-l