Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB Movement from Sun to AIX ?

Re: DB Movement from Sun to AIX ?

From: Thomas Day <tomday2_at_gmail.com>
Date: Wed, 27 Jul 2005 08:43:37 -0400
Message-ID: <a8c5045905072705436702e23f@mail.gmail.com>


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
Received on Wed Jul 27 2005 - 07:46:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US