DBA Data[Home] [Help]

VIEW: SYS.USER_REPGENOBJECTS

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, user_users u
where r.base_sname = u.username
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
, USER_USERS U WHERE R.BASE_SNAME = U.USERNAME