repgroup.sql

---------------------------------------------------------------------------
-- Filename:    repgroup.sql
-- Purpose:     Lists status of all replication groups.
-- Author:      Chas. Dye (cdye@excitecorp.com)
-- Date:        28-Jun-1996
---------------------------------------------------------------------------
column MASTER           heading "Mast|Site"             format a4
column MASTERDEF        heading "Mast|Def|Site"         format a4
column STATUS           heading "Status"                format a9
column GNAME            heading "Group"                 format a12
column SCHEMA_COMMENT   heading "Comment"               format a45

SELECT  g.gname,
        decode(g.master, 'N', 'No', 'Y', 'Yes') master, 
        decode(s.masterdef, 'Y', 'Yes', 'N', 'No') masterdef,
        g.status,
        g.schema_comment
FROM    dba_repgroup g,
        dba_repsites s
WHERE   g.gname = s.gname
AND     s.my_dblink = 'Y'
/

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