repcaterr.sql
--------------------------------------------------------------------------- -- Filename: repcaterr.sql -- Purpose: Lists entries in dba_repcatlog with error status. -- Author: Chas. Dye (cdye@excitecorp.com) -- Date: 28-Jun-1996 --------------------------------------------------------------------------- column ID heading "Id" format 9999 column SOURCE heading "Source" format a20 column SNAME heading "Schema" format a8 column REQUEST heading "Request" format a22 column ONAME heading "Object" format a20 column ERRNUM heading "Error" format 99999 column MESSAGE heading "Message" format a74 SELECT id, status, sname, request, oname, errnum FROM dba_repcatlog WHERE status = 'ERROR' ORDER BY id / SELECT id, message FROM dba_repcatlog WHERE status = 'ERROR' ORDER BY id / set head off SELECT 'Run these commands to purge...' FROM dual / set head on SELECT 'EXECUTE dbms_repcat.purge_master_log('|| id ||', ' ||chr(39)||rtrim(source)||chr(39)||', ' ||chr(39)||gname||chr(39)||');' command FROM dba_repcatlog WHERE status = 'ERROR' /
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.