-------------------------------------------------------
--  what : tbrepgrp.sql 
--  when : 11 Jul 2007
--   why : reports the replication group that a
--         table belongs to
-- where :  
--   how : 
--   who : David Clement, SUM Global Technology
--   fix :
-----------------------------------------------------------

SELECT r.NAME, s.NAME
  FROM dba_rgroup r, dba_snapshots s
 WHERE r.refgroup = s.refresh_group
   AND s.NAME LIKE '&1'
/