eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.KU$_M_VIEW_VIEW_BASE

Source

View Text - Preformatted


select '2',
         case when dbms_metadata.get_version >= '12.00.00.00.00' then '4'
              when dbms_metadata.get_version >= '11.02.00.00.00' then '3'
              when dbms_metadata.get_version >= '11.00.00.00.00' then '2'
              when dbms_metadata.get_version >= '10.00.00.00.00' then '1'
              else '0'
         end,
         s.sowner,
         s.vname,
         s.tname,
         s.mowner,
         s.master,
         s.mlink,
         (select o.obj# from sys.obj$ o, user$ u
          where  dbms_metadata.get_version >= '12.00.00.00.00'
            and s.mlink is null
            and o.owner# = u.user#
            and s.mowner = u.name
            and s.master = o.name
            and o.type#  = 2
            and o.linkname is null), /* interested in local objects only
                                        (see  s.mlink is null ) */
         TO_CHAR(s.snapshot,'YYYY-MM-DD HH24:MI:SS'),
         s.snapid,
         DECODE(s.auto_fast, 'C', 'COMPLETE', 'F', 'FAST', '?', 'FORCE',
                NULL, 'FORCE', 'N', 'NEVER', 'ERROR'),
         s.auto_fun,
         to_char(s.auto_date,'YYYY/MM/DD HH24:MI:SS'),
         s.uslog,
         s.status,
         s.master_version,
         s.tables,
         s.flag,
         s.flag2,
         case when dbms_metadata.get_version >= '11.02.00.00.00'
           then NVL(s.flag3, 0)
           else 0
         end,
         s.lobmaskvec,
         s.mas_roll_seg,
         s.rscn,
         s.instsite,
         NVL(s.flavor_id, 0),
         s.objflag,
         s.sna_type_owner,
         s.sna_type_name,
         s.mas_type_owner,
         s.mas_type_name,
         s.parent_sowner,
         s.parent_vname,
         s.query_len,
         sys.dbms_metadata_util.long2clob(s.query_len, 'sys.snap$',
                                            'query_txt', s.rowid),
         sys.dbms_metadata.parse_query(s.sowner, s.query_len, 'sys.snap$',
                                       'query_txt', s.rowid),
--         sys.dbms_metadata_util.long2vcnt(s.query_len, 'sys.snap$',
--                                            'query_txt', s.rowid),
         NULL,
         s.rel_query,
         (select rg.rollback_seg
          from   sys.rgroup$ rg
          where  rg.owner = s.sowner
             and rg.name = s.vname),
         p.value$,
         s.syn_count,
         cast(multiset(select srt.tablenum,
                              TO_CHAR(srt.snaptime,'YYYY-MM-DD HH24:MI:SS'),
                              srt.mowner,
                              srt.master,
                              srt.masflag,
                              srt.masobj#,
                              TO_CHAR(srt.loadertime,'YYYY-MM-DD HH24:MI:SS'),
                              srt.refscn,
                              TO_CHAR(srt.lastsuccess,'YYYY-MM-DD HH24:MI:SS'),
                              srt.fcmaskvec,
                              srt.ejmaskvec,
                              srt.sub_handle,
                              srt.change_view,
                              (select count(*)
                               from   sys.snap_colmap$ scm
                               where  srt.vname = scm.vname
                               and    srt.sowner = scm.sowner
                               and    srt.instsite = scm.instsite
                               and    srt.tablenum = scm.tabnum),
                              cast(multiset(select scm.snacol,
                                                   scm.mascol,
                                                   scm.maspos,
                                                   scm.colrole,
                                                   scm.snapos
                                            from   sys.snap_colmap$ scm
                                            where  srt.vname = scm.vname
                                            and    srt.sowner = scm.sowner
                                            and    srt.instsite = scm.instsite
                                            and    srt.tablenum = scm.tabnum
                                            order by scm.maspos)
                                            as ku$_m_view_scm_list_t)
                       from   sys.snap_reftime$ srt
                       where  s.vname    = srt.vname
                          and s.sowner   = srt.sowner
                          and s.instsite = srt.instsite
                       order by srt.tablenum, srt.mowner, srt.master)
                       as ku$_m_view_srt_list_t),
         nvl((select sm.mflags
              from   sys.obj$ o, sys.user$ u, sum$ sm
              where  u.user# = o.owner#
              and    u.name = s.sowner
              and    o.name = s.vname
              and    o.obj# = sm.obj#), 0),
         nvl((select sm.xpflags
              from   sys.obj$ o, sys.user$ u, sum$ sm
              where  u.user# = o.owner#
              and    u.name = s.sowner
              and    o.name = s.vname
              and    o.obj# = sm.obj#), 0),
         nvl((select sm.zmapscale
              from   sys.obj$ o, sys.user$ u, sum$ sm
              where  u.user# = o.owner#
              and    u.name = s.sowner
              and    o.name = s.vname
              and    o.obj# = sm.obj#), 0),
         nvl((select sm.evaledition#
              from   sys.obj$ o, sys.user$ u, sum$ sm
              where  u.user# = o.owner#
              and    u.name = s.sowner
              and    o.name = s.vname
              and    o.obj# = sm.obj#), 0),
         nvl((select sm.unusablebefore#
              from   sys.obj$ o, sys.user$ u, sum$ sm
              where  u.user# = o.owner#
              and    u.name = s.sowner
              and    o.name = s.vname
              and    o.obj# = sm.obj#), 0),
         nvl((select sm.unusablebeginning#
              from   sys.obj$ o, sys.user$ u, sum$ sm
              where  u.user# = o.owner#
              and    u.name = s.sowner
              and    o.name = s.vname
              and    o.obj# = sm.obj#), 0)
  from   snap$ s, sys.props$ p
  where  p.name  = 'GLOBAL_DB_NAME'
  /* for < 11.2, exclude MVs using scn-based refresh */
  and (dbms_metadata.get_version >= '11.02.00.00.00'
       or
       (dbms_metadata.get_version < '11.02.00.00.00' and bitand(s.flag3, 1)=0))

View Text - HTML Formatted

SELECT '2'
, CASE WHEN DBMS_METADATA.GET_VERSION >= '12.00.00.00.00' THEN '4' WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN '3' WHEN DBMS_METADATA.GET_VERSION >= '11.00.00.00.00' THEN '2' WHEN DBMS_METADATA.GET_VERSION >= '10.00.00.00.00' THEN '1' ELSE '0' END
, S.SOWNER
, S.VNAME
, S.TNAME
, S.MOWNER
, S.MASTER
, S.MLINK
, (SELECT O.OBJ#
FROM SYS.OBJ$ O
, USER$ U
WHERE DBMS_METADATA.GET_VERSION >= '12.00.00.00.00'
AND S.MLINK IS NULL
AND O.OWNER# = U.USER#
AND S.MOWNER = U.NAME
AND S.MASTER = O.NAME
AND O.TYPE# = 2
AND O.LINKNAME IS NULL)
, /* INTERESTED IN LOCAL OBJECTS ONLY (SEE S.MLINK IS NULL ) */ TO_CHAR(S.SNAPSHOT
, 'YYYY-MM-DD HH24:MI:SS')
, S.SNAPID
, DECODE(S.AUTO_FAST
, 'C'
, 'COMPLETE'
, 'F'
, 'FAST'
, '?'
, 'FORCE'
, NULL
, 'FORCE'
, 'N'
, 'NEVER'
, 'ERROR')
, S.AUTO_FUN
, TO_CHAR(S.AUTO_DATE
, 'YYYY/MM/DD HH24:MI:SS')
, S.USLOG
, S.STATUS
, S.MASTER_VERSION
, S.TABLES
, S.FLAG
, S.FLAG2
, CASE WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN NVL(S.FLAG3
, 0) ELSE 0 END
, S.LOBMASKVEC
, S.MAS_ROLL_SEG
, S.RSCN
, S.INSTSITE
, NVL(S.FLAVOR_ID
, 0)
, S.OBJFLAG
, S.SNA_TYPE_OWNER
, S.SNA_TYPE_NAME
, S.MAS_TYPE_OWNER
, S.MAS_TYPE_NAME
, S.PARENT_SOWNER
, S.PARENT_VNAME
, S.QUERY_LEN
, SYS.DBMS_METADATA_UTIL.LONG2CLOB(S.QUERY_LEN
, 'SYS.SNAP$'
, 'QUERY_TXT'
, S.ROWID)
, SYS.DBMS_METADATA.PARSE_QUERY(S.SOWNER
, S.QUERY_LEN
, 'SYS.SNAP$'
, 'QUERY_TXT'
, S.ROWID)
, -- SYS.DBMS_METADATA_UTIL.LONG2VCNT(S.QUERY_LEN
, 'SYS.SNAP$'
, -- 'QUERY_TXT'
, S.ROWID)
, NULL
, S.REL_QUERY
, (SELECT RG.ROLLBACK_SEG
FROM SYS.RGROUP$ RG
WHERE RG.OWNER = S.SOWNER
AND RG.NAME = S.VNAME)
, P.VALUE$
, S.SYN_COUNT
, CAST(MULTISET(SELECT SRT.TABLENUM
, TO_CHAR(SRT.SNAPTIME
, 'YYYY-MM-DD HH24:MI:SS')
, SRT.MOWNER
, SRT.MASTER
, SRT.MASFLAG
, SRT.MASOBJ#
, TO_CHAR(SRT.LOADERTIME
, 'YYYY-MM-DD HH24:MI:SS')
, SRT.REFSCN
, TO_CHAR(SRT.LASTSUCCESS
, 'YYYY-MM-DD HH24:MI:SS')
, SRT.FCMASKVEC
, SRT.EJMASKVEC
, SRT.SUB_HANDLE
, SRT.CHANGE_VIEW
, (SELECT COUNT(*)
FROM SYS.SNAP_COLMAP$ SCM
WHERE SRT.VNAME = SCM.VNAME
AND SRT.SOWNER = SCM.SOWNER
AND SRT.INSTSITE = SCM.INSTSITE
AND SRT.TABLENUM = SCM.TABNUM)
, CAST(MULTISET(SELECT SCM.SNACOL
, SCM.MASCOL
, SCM.MASPOS
, SCM.COLROLE
, SCM.SNAPOS
FROM SYS.SNAP_COLMAP$ SCM
WHERE SRT.VNAME = SCM.VNAME
AND SRT.SOWNER = SCM.SOWNER
AND SRT.INSTSITE = SCM.INSTSITE
AND SRT.TABLENUM = SCM.TABNUM ORDER BY SCM.MASPOS) AS KU$_M_VIEW_SCM_LIST_T)
FROM SYS.SNAP_REFTIME$ SRT
WHERE S.VNAME = SRT.VNAME
AND S.SOWNER = SRT.SOWNER
AND S.INSTSITE = SRT.INSTSITE ORDER BY SRT.TABLENUM
, SRT.MOWNER
, SRT.MASTER) AS KU$_M_VIEW_SRT_LIST_T)
, NVL((SELECT SM.MFLAGS
FROM SYS.OBJ$ O
, SYS.USER$ U
, SUM$ SM
WHERE U.USER# = O.OWNER#
AND U.NAME = S.SOWNER
AND O.NAME = S.VNAME
AND O.OBJ# = SM.OBJ#)
, 0)
, NVL((SELECT SM.XPFLAGS
FROM SYS.OBJ$ O
, SYS.USER$ U
, SUM$ SM
WHERE U.USER# = O.OWNER#
AND U.NAME = S.SOWNER
AND O.NAME = S.VNAME
AND O.OBJ# = SM.OBJ#)
, 0)
, NVL((SELECT SM.ZMAPSCALE
FROM SYS.OBJ$ O
, SYS.USER$ U
, SUM$ SM
WHERE U.USER# = O.OWNER#
AND U.NAME = S.SOWNER
AND O.NAME = S.VNAME
AND O.OBJ# = SM.OBJ#)
, 0)
, NVL((SELECT SM.EVALEDITION#
FROM SYS.OBJ$ O
, SYS.USER$ U
, SUM$ SM
WHERE U.USER# = O.OWNER#
AND U.NAME = S.SOWNER
AND O.NAME = S.VNAME
AND O.OBJ# = SM.OBJ#)
, 0)
, NVL((SELECT SM.UNUSABLEBEFORE#
FROM SYS.OBJ$ O
, SYS.USER$ U
, SUM$ SM
WHERE U.USER# = O.OWNER#
AND U.NAME = S.SOWNER
AND O.NAME = S.VNAME
AND O.OBJ# = SM.OBJ#)
, 0)
, NVL((SELECT SM.UNUSABLEBEGINNING#
FROM SYS.OBJ$ O
, SYS.USER$ U
, SUM$ SM
WHERE U.USER# = O.OWNER#
AND U.NAME = S.SOWNER
AND O.NAME = S.VNAME
AND O.OBJ# = SM.OBJ#)
, 0)
FROM SNAP$ S
, SYS.PROPS$ P
WHERE P.NAME = 'GLOBAL_DB_NAME' /* FOR < 11.2
, EXCLUDE MVS USING SCN-BASED REFRESH */
AND (DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' OR (DBMS_METADATA.GET_VERSION < '11.02.00.00.00'
AND BITAND(S.FLAG3
, 1)=0))