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
