repres.sql

---------------------------------------------------------------------------
-- Filename:    repres.sql
-- Purpose:     Lists all conflict resolution techniques.
-- Author:      Chas. Dye (cdye@excitecorp.com)
-- Date:        27-May-1998
---------------------------------------------------------------------------
column sname            heading "Schema|Name"   format a8
column oname            heading "Table|Name"    format a25
column conflict_type    heading "Conflict|Type" format a10
column method_name      heading "Method"        format a18
column sequence_no      heading "Seq"           format 99

clear breaks
break on sname on oname skip 1

SELECT  sname,
        substr(oname, 1, 25)            oname,
        conflict_type,
        method_name,
        sequence_no
FROM    dba_represolution
ORDER BY sname, oname
/

clear breaks

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.

Start your free trial