VIEW: SYS._DBA_XSTREAM_OUT_ADT_PK_TABLES

Source

View Text - Preformatted

select u.name, o.name, o.obj# from sys.user$ u, sys.obj$ o, sys.col$ c
where o.owner# = u.user#
  and c.obj# = o.obj#
  and c.type# = 121
  and o.type# = 2
  and exists
  (select 1 from sys.ccol$ ccol, sys.col$ c2, sys.cdef$ cd
                              where c.obj# = c2.obj#
                                and c.obj# = cd.obj#
                                and c.obj# = ccol.obj#
                                and c.col# = c2.col#
                                and ccol.con# = cd.con#
                                and ccol.intcol# = c2.intcol#
                                and bitand(c2.property, 32) = 32
                                and cd.type# = 2)

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, O.OBJ#
FROM SYS.USER$ U
, SYS.OBJ$ O
, SYS.COL$ C WHERE O.OWNER# = U.USER#
AND C.OBJ# = O.OBJ#
AND C.TYPE# = 121
AND O.TYPE# = 2
AND EXISTS (SELECT 1
FROM SYS.CCOL$ CCOL
, SYS.COL$ C2
, SYS.CDEF$ CD
WHERE C.OBJ# = C2.OBJ#
AND C.OBJ# = CD.OBJ#
AND C.OBJ# = CCOL.OBJ#
AND C.COL# = C2.COL#
AND CCOL.CON# = CD.CON#
AND CCOL.INTCOL# = C2.INTCOL#
AND BITAND(C2.PROPERTY
, 32) = 32
AND CD.TYPE# = 2)