VIEW: SYS.KU$_OIDINDEX_VIEW

Source

View Text - Preformatted

select i.bo#, ic.intcol#, o.name,
              decode(substr(o.name,1,5),'SYS_C',8,0),     -- mimic constr defer
              ( select value(s)
                from ku$_storage_view s
                where i.file#  = s.file_num
                and   i.block# = s.block_num
                and   i.ts#    = s.ts_num),
              (select value(s) from ku$_deferred_stg_view s
               where s.obj_num = i.obj#),
              ts.name, ts.blocksize,
              i.pctfree$,i.initrans,i.maxtrans
       from   sys.obj$ o, sys.ind$ i, sys.icol$ ic, sys.ts$ ts
       where  i.type# = 1
              and i.intcols = 1
              and ic.obj# = i.obj#
              and ic.intcol# = (select c.intcol#   -- Only 1 OID col per table
                                from sys.col$ c
                                where c.obj#=i.bo#
                                and bitand(c.property,2)=2)
              and o.obj# = i.obj#
              and ts.ts# = i.ts#

View Text - HTML Formatted

SELECT I.BO#
, IC.INTCOL#
, O.NAME
, DECODE(SUBSTR(O.NAME
, 1
, 5)
, 'SYS_C'
, 8
, 0)
, -- MIMIC CONSTR DEFER ( SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE I.FILE# = S.FILE_NUM
AND I.BLOCK# = S.BLOCK_NUM
AND I.TS# = S.TS_NUM)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = I.OBJ#)
, TS.NAME
, TS.BLOCKSIZE
, I.PCTFREE$
, I.INITRANS
, I.MAXTRANS
FROM SYS.OBJ$ O
, SYS.IND$ I
, SYS.ICOL$ IC
, SYS.TS$ TS
WHERE I.TYPE# = 1
AND I.INTCOLS = 1
AND IC.OBJ# = I.OBJ#
AND IC.INTCOL# = (SELECT C.INTCOL# -- ONLY 1 OID COL PER TABLE
FROM SYS.COL$ C
WHERE C.OBJ#=I.BO#
AND BITAND(C.PROPERTY
, 2)=2)
AND O.OBJ# = I.OBJ#
AND TS.TS# = I.TS#