Re: How to determine the reason for snapshot autorefresh failure?

On 1月29日, 上午1时38分, DA Morgan <damor..._at_psoug.org> wrote:
> jshen...._at_gmail.com wrote:
> > hi,
>
> > we have a central DB which is updated frequently. there are three
> > satallite DB which much keep syncronized with central DB at 5min
> > interval. there are six tables need to be syncronized.
>
> > We have three dbms_jobs which are run every 5min. In past weeks ,
> > we experience three times of syncronization failure. But, when I
> > noticed data in satalite DB was not syncronized with central DB, I
> > run the three dbms_job manually successfully. But, satalite DB conten
> > does not updated at all. I have to rebuild snapshot and run a full
> > syncronization manually.
>
> > How could I determine why data syncronization failed ? why did
> > manual syncronization succeed with no data updated?
>
> > regards
>
> > Joe
>
> Version number?
>
> Does DBA_JOBS show failures?
> --

Oracle 8.1.7,
There is no error shown by run those jobs manually under SQL>.

Joe Received on Tue Jan 30 2007 - 09:25:17 CST