VIEW: SYS.DISK_AND_FIXED_OBJECTS

Source

View Text - Preformatted

select co.obj#, co.owner#, co.name, co.type#, co.remoteowner, co.linkname,
       co.defining_edition
from sys."_CURRENT_EDITION_OBJ" co
union all
select kobjn_kqfp, 0, name_kqfp,
decode(type_kqfp, 1, 9, 2, 11, 3, 10, 0), NULL, NULL, NULL
from sys.x$kqfp
union all
select kqftaobj, 0, kqftanam, 2, NULL, NULL, NULL
from sys.x$kqfta
union all
select kqfviobj, 0, kqfvinam, 4, NULL, NULL, NULL
from sys.x$kqfvi

View Text - HTML Formatted

SELECT CO.OBJ#
, CO.OWNER#
, CO.NAME
, CO.TYPE#
, CO.REMOTEOWNER
, CO.LINKNAME
, CO.DEFINING_EDITION FROM SYS."_CURRENT_EDITION_OBJ" CO UNION ALL SELECT KOBJN_KQFP
, 0
, NAME_KQFP
, DECODE(TYPE_KQFP
, 1
, 9
, 2
, 11
, 3
, 10
, 0)
, NULL
, NULL
, NULL FROM SYS.X$KQFP UNION ALL SELECT KQFTAOBJ
, 0
, KQFTANAM
, 2
, NULL
, NULL
, NULL FROM SYS.X$KQFTA UNION ALL SELECT KQFVIOBJ
, 0
, KQFVINAM
, 4
, NULL
, NULL
, NULL FROM SYS.X$KQFVI