rem -----------------------------------------------------------------------
rem Filename:   reperrs.sql
rem Purpose:    Try to apply transaction in error and delete the remaining
rem             transactions that is still in error.
rem Date:       06-Feb-2006
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

connect repadmin/repadmin

spool apply_errors.sql
select 'exec dbms_defer_sys.execute_error(''' || deferred_tran_id ||''','''||
       destination || ''')'
from   deferror;
spool off
@apply_errors
commit;

spool delete_errors.sql
select 'exec dbms_defer_sys.delete_error(''' || deferred_tran_id ||''','''||
       destination || ''')'
from   deferror;
spool off
@delete_errors
commit; 

-- Deletes all errors in one go...
-- execute dbms_defer_sys.delete_error(NULL,NULL);

-- Clear entries from the local RepCatLog (DBA_REPCATLOG)
-- exec dbms_repcat.purge_master_log;