VIEW: SYS.DBA_REGISTERED_MVIEW_GROUPS

Source

View Text - Preformatted

select s.gname, s.dblink, s.group_comment,
          decode(s.rep_type, 1, 'ORACLE 7',
                             2, 'ORACLE 8',
                             3, 'REPAPI',
                                'UNKNOWN'),
          f.fname, s.gowner
from system.repcat$_snapgroup s, system.repcat$_flavors f
  WHERE s.gname     = f.gname (+)
    AND s.flavor_id = f.flavor_id (+)
    AND s.gowner    = f.gowner (+)

View Text - HTML Formatted

SELECT S.GNAME
, S.DBLINK
, S.GROUP_COMMENT
, DECODE(S.REP_TYPE
, 1
, 'ORACLE 7'
, 2
, 'ORACLE 8'
, 3
, 'REPAPI'
, 'UNKNOWN')
, F.FNAME
, S.GOWNER FROM SYSTEM.REPCAT$_SNAPGROUP S
, SYSTEM.REPCAT$_FLAVORS F
WHERE S.GNAME = F.GNAME (+)
AND S.FLAVOR_ID = F.FLAVOR_ID (+)
AND S.GOWNER = F.GOWNER (+)