VIEW: SYS.ALL_REPGENERATED

Source

View Text - Preformatted

select r.sname, r.oname, r.type, r.base_sname, r.base_oname, r.base_type,
  r.package_prefix, r.procedure_prefix, r.distributed, r.reason
from repcat_generated r, all_users u, all_objects o
where r.base_sname = u.username
  and r.base_sname = o.owner
  and r.base_oname = o.object_name
  and (r.base_type = o.object_type
       or (r.base_type = 'SNAPSHOT'
           and o.object_type IN ('VIEW','TABLE')))
  and ((r.reason  = 'PROCEDURAL REPLICATION WRAPPER' and r.type != 'SYNONYM')
     or r.reason != 'PROCEDURAL REPLICATION WRAPPER')
union
select r.sname, r.oname, r.type, r.base_sname, r.base_oname, r.base_type,
  r.package_prefix, r.procedure_prefix, r.distributed, r.reason
from user_repgenerated r
union
select r.sname, r.oname, r.type, r.base_sname, r.base_oname,
  r.base_type, r.package_prefix, r.procedure_prefix,
  r.distributed, r.reason
from repcat_generated r, all_users u, repcat_repobject ro
where r.base_sname = u.username
and ((r.reason  = 'PROCEDURAL REPLICATION WRAPPER'
  and r.type != 'SYNONYM')
or r.reason != 'PROCEDURAL REPLICATION WRAPPER')
and r.sname = ro.sname
and r.oname = ro.oname
and r.type = ro.type
and (ro.gname, ro.gowner) in
(select nvl(rp.gname,ro.gname), nvl(rp.owner, ro.gowner)
 from user_repgroup_privileges rp
 where rp.proxy_snapadmin='Y')

View Text - HTML Formatted

SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.BASE_SNAME
, R.BASE_ONAME
, R.BASE_TYPE
, R.PACKAGE_PREFIX
, R.PROCEDURE_PREFIX
, R.DISTRIBUTED
, R.REASON FROM REPCAT_GENERATED R
, ALL_USERS U
, ALL_OBJECTS O WHERE R.BASE_SNAME = U.USERNAME
AND R.BASE_SNAME = O.OWNER
AND R.BASE_ONAME = O.OBJECT_NAME
AND (R.BASE_TYPE = O.OBJECT_TYPE OR (R.BASE_TYPE = 'SNAPSHOT'
AND O.OBJECT_TYPE IN ('VIEW'
, 'TABLE')))
AND ((R.REASON = 'PROCEDURAL REPLICATION WRAPPER'
AND R.TYPE != 'SYNONYM') OR R.REASON != 'PROCEDURAL REPLICATION WRAPPER') UNION SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.BASE_SNAME
, R.BASE_ONAME
, R.BASE_TYPE
, R.PACKAGE_PREFIX
, R.PROCEDURE_PREFIX
, R.DISTRIBUTED
, R.REASON FROM USER_REPGENERATED R UNION SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.BASE_SNAME
, R.BASE_ONAME
, R.BASE_TYPE
, R.PACKAGE_PREFIX
, R.PROCEDURE_PREFIX
, R.DISTRIBUTED
, R.REASON FROM REPCAT_GENERATED R
, ALL_USERS U
, REPCAT_REPOBJECT RO WHERE R.BASE_SNAME = U.USERNAME AND ((R.REASON = 'PROCEDURAL REPLICATION WRAPPER'
AND R.TYPE != 'SYNONYM') OR R.REASON != 'PROCEDURAL REPLICATION WRAPPER') AND R.SNAME = RO.SNAME AND R.ONAME = RO.ONAME AND R.TYPE = RO.TYPE AND (RO.GNAME
, RO.GOWNER) IN (SELECT NVL(RP.GNAME
, RO.GNAME)
, NVL(RP.OWNER
, RO.GOWNER)
FROM USER_REPGROUP_PRIVILEGES RP
WHERE RP.PROXY_SNAPADMIN='Y')