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. -- //www.freelists.org/webpage/oracle-l