VIEW: SYS._ACTUAL_EDITION_OBJ

Source

View Text - Preformatted

select o."OBJ#",o."DATAOBJ#",o."OWNER#",o."NAME",o."NAMESPACE",o."SUBNAME",o."TYPE#",o."CTIME",o."MTIME",o."STIME",o."STATUS",o."REMOTEOWNER",o."LINKNAME",o."FLAGS",o."OID$",o."SPARE1",o."SPARE2",o."SPARE3",o."SPARE4",o."SPARE5",o."SPARE6",o."SIGNATURE",o."SPARE7",o."SPARE8",o."SPARE9",
  
       o.spare3,
       case when (o.type# not in (select ue.type# from user_editioning$ ue
                                  where ue.user# = o.spare3) or
                  bitand(o.flags, 1048576) = 1048576 or
                  bitand(u.spare1, 16) = 0) then
         null
       when (u.type# = 2) then
        (select name from obj$ where obj# = u.spare2)
       else
        'ORA$BASE'
       end
from obj$ o, user$ u
where o.owner# = u.user#
  and o.type# != 88
  

View Text - HTML Formatted

SELECT O."OBJ#"
, O."DATAOBJ#"
, O."OWNER#"
, O."NAME"
, O."NAMESPACE"
, O."SUBNAME"
, O."TYPE#"
, O."CTIME"
, O."MTIME"
, O."STIME"
, O."STATUS"
, O."REMOTEOWNER"
, O."LINKNAME"
, O."FLAGS"
, O."OID$"
, O."SPARE1"
, O."SPARE2"
, O."SPARE3"
, O."SPARE4"
, O."SPARE5"
, O."SPARE6"
, O."SIGNATURE"
, O."SPARE7"
, O."SPARE8"
, O."SPARE9"
, O.SPARE3
, CASE WHEN (O.TYPE# NOT IN (SELECT UE.TYPE#
FROM USER_EDITIONING$ UE
WHERE UE.USER# = O.SPARE3) OR BITAND(O.FLAGS
, 1048576) = 1048576 OR BITAND(U.SPARE1
, 16) = 0) THEN NULL WHEN (U.TYPE# = 2) THEN (SELECT NAME
FROM OBJ$
WHERE OBJ# = U.SPARE2) ELSE 'ORA$BASE' END FROM OBJ$ O
, USER$ U WHERE O.OWNER# = U.USER#
AND O.TYPE# != 88