Truncate $mlog table without stop DBMS_jobs

hi,

   we run a Oracle8.1.7 database whose content is snapshoted to other three satallite oracle DB. The refreshing period is 5min. We set up DBMS_jobs to execute refreshing automatically.

 Last Saturday, we falled into Oracle software bug ORA-12008 error in materialized view refresh path( ORA-00001 ORA-02291 ORA-02292), and automatic refreshing failed. After doing full refreshing, automatic refreshing recovered. But, we found one of $mlog table is much bigger than usual. I want to truncate the table to improve performance.

  Someone suggested, before $mlog truncating operation DBMS jobs and other applications should be stopped. Because applications may modify dictionary of snapshotted item. A manual full refreshed should be executed before truncate operation.

  As execution time of DBMS_jobs on three satallite DB do not coincide with each other.

Is that possible to do truncation operation without stoppting any application and DBMS_jobs?

 Joe Received on Tue Mar 27 2007 - 11:36:54 CDT