VIEW: SYS.KU$_OPTION_OBJNUM_VIEW

Source

View Text - Preformatted

select o.obj_num, 'T', value(o),i.tgt_type, i.flags, i.tag
  from ku$_expreg i, ku$_schemaobj_view o
  where ((bitand(i.flags,1)=0 and
          o.name=i.tgt_object and
          (bitand(i.flags,8)=0)) or
         (bitand(i.flags,1)=1 and
          o.name like i.tgt_object and
           -- check for excluded object
          (select count(*)
           from ku$_expreg xi
           where (bitand(xi.flags,8)=8)
                 and i.tgt_schema = xi.tgt_schema
                 and xi.tgt_object = o.name) = 0 ))
    AND o.owner_name=i.tgt_schema
    AND i.tgt_type=o.type_num
-- in 12.1 (12.2?) we need to check for a table being remapped to a view
--  for downgrade. This is not needed, or available, prior to 12.
--    AND SYS.DBMS_METADATA_UTIL.OT_TBL_NOT_VIEW(
--         i.schema,i.package,i.tgt_schema,o.name)=1

View Text - HTML Formatted

SELECT O.OBJ_NUM
, 'T'
, VALUE(O)
, I.TGT_TYPE
, I.FLAGS
, I.TAG
FROM KU$_EXPREG I
, KU$_SCHEMAOBJ_VIEW O
WHERE ((BITAND(I.FLAGS
, 1)=0 AND O.NAME=I.TGT_OBJECT AND (BITAND(I.FLAGS
, 8)=0)) OR (BITAND(I.FLAGS
, 1)=1 AND O.NAME LIKE I.TGT_OBJECT AND -- CHECK FOR EXCLUDED OBJECT (SELECT COUNT(*)
FROM KU$_EXPREG XI
WHERE (BITAND(XI.FLAGS
, 8)=8)
AND I.TGT_SCHEMA = XI.TGT_SCHEMA
AND XI.TGT_OBJECT = O.NAME) = 0 ))
AND O.OWNER_NAME=I.TGT_SCHEMA
AND I.TGT_TYPE=O.TYPE_NUM -- IN 12.1 (12.2?) WE NEED TO CHECK FOR A TABLE BEING REMAPPED TO A VIEW -- FOR DOWNGRADE. THIS IS NOT NEEDED
, OR AVAILABLE
, PRIOR TO 12. --
AND SYS.DBMS_METADATA_UTIL.OT_TBL_NOT_VIEW( -- I.SCHEMA
, I.PACKAGE
, I.TGT_SCHEMA
, O.NAME)=1