Failed with snapshot replication frequently

From: <jshen.cad_at_gmail.com>
Date: 22 Jan 2007 09:22:11 -0800
Message-ID: <1169486531.906176.235940@s34g2000cwa.googlegroups.com>

hi,

we run three oracle instance on three servers.

Two slave server maitein snapshot of some table on master server. We run three jobs on two slave server to sync. table with master db. All DB instances are oracle 8.17.

Two weeks ago, we added more tables into snapshot sync. lists. But, in the past days we met
two times of snapshot sync. failure.

when such problem happens, I could exec dbms_job.run(102) successfully, but there does exist some data failed to be syncronized. With full re-sync, there comes ORA12034 error.

How could we solve the problem ? Should we add another dbms job ?

regards

Joe Received on Mon Jan 22 2007 - 11:22:11 CST