VIEW: SYS.KU$_ADD_SNAP_VIEW

Source

View Text - Preformatted

select  r.refgroup,
  sys.dbms_metadata_util.get_refresh_add_user(rc.owner,
                                        rc.name,rc.type#,rc.instsite) ,
  sys.dbms_metadata_util.get_refresh_add_dba(rc.owner,
                                        rc.name,rc.type#,rc.instsite)
  from rgroup$ r, rgchild$ rc
  where  r.refgroup = rc.refgroup

View Text - HTML Formatted

SELECT R.REFGROUP
, SYS.DBMS_METADATA_UTIL.GET_REFRESH_ADD_USER(RC.OWNER
, RC.NAME
, RC.TYPE#
, RC.INSTSITE)
, SYS.DBMS_METADATA_UTIL.GET_REFRESH_ADD_DBA(RC.OWNER
, RC.NAME
, RC.TYPE#
, RC.INSTSITE)
FROM RGROUP$ R
, RGCHILD$ RC
WHERE R.REFGROUP = RC.REFGROUP