VIEW: SYS.ALL_REPOBJECT

Source

View Text - Preformatted

select r.sname, r.oname, r.type, r.status, r.generation_status, r.id,
       r.object_comment, r.gname, r.min_communication,
       r.trigflag replication_trigger_exists, r.internal_package_exists,
       r.gowner, r.nested_table
from repcat_repobject r, all_objects o
where (r.sname = 'PUBLIC' or r.sname in (select u.username from all_users u))
  and r.sname = o.owner
  and r.oname = o.object_name
  and r.type != 'INTERNAL PACKAGE'
  and (r.type = o.object_type
       or (r.type = 'SNAPSHOT'
           and o.object_type IN ('VIEW','TABLE')))
union
select r.sname, r.oname, r.type, r.status, r.generation_status, r.id,
       r.object_comment, r.gname, r.min_communication,
       r.replication_trigger_exists, r.internal_package_exists, r.group_owner,
       r.nested_table
from user_repobject r
union
select r.sname, r.oname, r.type, r.status, r.generation_status,
       r.id, r.object_comment, r.gname, r.min_communication,
       r.trigflag replication_trigger_exists, r.internal_package_exists,
       r.gowner, r.nested_table
from repcat_repobject r
where (r.sname = 'PUBLIC' or r.sname in
        (select u.username from all_users u))
and (r.gname, r.gowner) in
(select nvl(rp.gname,r.gname), nvl(rp.owner, r.gowner)
 from user_repgroup_privileges rp
 where rp.proxy_snapadmin='Y')

View Text - HTML Formatted

SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.STATUS
, R.GENERATION_STATUS
, R.ID
, R.OBJECT_COMMENT
, R.GNAME
, R.MIN_COMMUNICATION
, R.TRIGFLAG REPLICATION_TRIGGER_EXISTS
, R.INTERNAL_PACKAGE_EXISTS
, R.GOWNER
, R.NESTED_TABLE FROM REPCAT_REPOBJECT R
, ALL_OBJECTS O WHERE (R.SNAME = 'PUBLIC' OR R.SNAME IN (SELECT U.USERNAME
FROM ALL_USERS U))
AND R.SNAME = O.OWNER
AND R.ONAME = O.OBJECT_NAME
AND R.TYPE != 'INTERNAL PACKAGE'
AND (R.TYPE = O.OBJECT_TYPE OR (R.TYPE = 'SNAPSHOT'
AND O.OBJECT_TYPE IN ('VIEW'
, 'TABLE'))) UNION SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.STATUS
, R.GENERATION_STATUS
, R.ID
, R.OBJECT_COMMENT
, R.GNAME
, R.MIN_COMMUNICATION
, R.REPLICATION_TRIGGER_EXISTS
, R.INTERNAL_PACKAGE_EXISTS
, R.GROUP_OWNER
, R.NESTED_TABLE FROM USER_REPOBJECT R UNION SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.STATUS
, R.GENERATION_STATUS
, R.ID
, R.OBJECT_COMMENT
, R.GNAME
, R.MIN_COMMUNICATION
, R.TRIGFLAG REPLICATION_TRIGGER_EXISTS
, R.INTERNAL_PACKAGE_EXISTS
, R.GOWNER
, R.NESTED_TABLE FROM REPCAT_REPOBJECT R WHERE (R.SNAME = 'PUBLIC' OR R.SNAME IN (SELECT U.USERNAME
FROM ALL_USERS U)) AND (R.GNAME
, R.GOWNER) IN (SELECT NVL(RP.GNAME
, R.GNAME)
, NVL(RP.OWNER
, R.GOWNER)
FROM USER_REPGROUP_PRIVILEGES RP
WHERE RP.PROXY_SNAPADMIN='Y')