Re: DB Movement from Sun to AIX ?

  • From: Thomas Day <tomday2@xxxxxxxxx>
  • To: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
  • Date: Wed, 27 Jul 2005 08:43:37 -0400

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.

Other related posts: