VIEW: SYS.DBA_SUBPART_KEY_COLUMNS

Source

View Text - Preformatted

select u.name, o.name, 'TABLE',
  decode(bitand(c.property, 1), 1, a.name, c.name), spc.pos#
from   obj$ o, subpartcol$ spc, col$ c, user$ u, attrcol$ a
where  spc.obj# = o.obj# and spc.obj# = c.obj#
       and c.intcol# = spc.intcol#
       and u.user# = o.owner#
       and c.obj# = a.obj#(+) and c.intcol# = a.intcol#(+)
       and o.subname IS NULL
       and o.namespace = 1 and o.remoteowner IS NULL and o.linkname IS NULL
union
select u.name, o.name, 'INDEX',
  decode(bitand(c.property, 1), 1, a.name, c.name), spc.pos#
from   obj$ o, subpartcol$ spc, col$ c, user$ u, ind$ i, attrcol$ a
where  spc.obj# = i.obj# and i.obj# = o.obj# and i.bo# = c.obj#
       and c.intcol# = spc.intcol#
       and u.user# = o.owner#
       and c.obj# = a.obj#(+) and c.intcol# = a.intcol#(+)
       and o.subname IS NULL
       and o.namespace = 4 and o.remoteowner IS NULL and o.linkname IS NULL

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, 'TABLE'
, DECODE(BITAND(C.PROPERTY
, 1)
, 1
, A.NAME
, C.NAME)
, SPC.POS# FROM OBJ$ O
, SUBPARTCOL$ SPC
, COL$ C
, USER$ U
, ATTRCOL$ A WHERE SPC.OBJ# = O.OBJ#
AND SPC.OBJ# = C.OBJ#
AND C.INTCOL# = SPC.INTCOL#
AND U.USER# = O.OWNER#
AND C.OBJ# = A.OBJ#(+)
AND C.INTCOL# = A.INTCOL#(+)
AND O.SUBNAME IS NULL
AND O.NAMESPACE = 1
AND O.REMOTEOWNER IS NULL
AND O.LINKNAME IS NULL UNION SELECT U.NAME
, O.NAME
, 'INDEX'
, DECODE(BITAND(C.PROPERTY
, 1)
, 1
, A.NAME
, C.NAME)
, SPC.POS# FROM OBJ$ O
, SUBPARTCOL$ SPC
, COL$ C
, USER$ U
, IND$ I
, ATTRCOL$ A WHERE SPC.OBJ# = I.OBJ#
AND I.OBJ# = O.OBJ#
AND I.BO# = C.OBJ#
AND C.INTCOL# = SPC.INTCOL#
AND U.USER# = O.OWNER#
AND C.OBJ# = A.OBJ#(+)
AND C.INTCOL# = A.INTCOL#(+)
AND O.SUBNAME IS NULL
AND O.NAMESPACE = 4
AND O.REMOTEOWNER IS NULL
AND O.LINKNAME IS NULL