Advanced replication - Errores por tabla | ExpoDBA

Advanced replication - Errores por tabla

Advanced replication - Errores por tabla

 col ERROR_MSG for a40
 set lines 200
 set pages 200
select SCHEMANAME, PACKAGENAME, ERROR_MSG, count(9) cant
from DEFCALL c, DEFERROR e
where 1=1
and c.DEFERRED_TRAN_ID = e.DEFERRED_TRAN_ID
and c.CALLNO = e.CALLNO
group by SCHEMANAME, PACKAGENAME, ERROR_MSG
order by 4;