VIEW: SYS.INT$DBA_DIRECTORIES

Source

View Text - Preformatted

select u.name, o.name, o.obj#, o.type#, d.os_path,
       decode(bitand(o.flags, 196608), 65536, 1, 131072, 1, 0),
       to_number(sys_context('USERENV', 'CON_ID'))
from sys.user$ u, sys.obj$ o, sys.x$dir d
where u.user# = o.owner#
  and o.obj# = d.obj#

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, O.OBJ#
, O.TYPE#
, D.OS_PATH
, DECODE(BITAND(O.FLAGS
, 196608)
, 65536
, 1
, 131072
, 1
, 0)
, TO_NUMBER(SYS_CONTEXT('USERENV'
, 'CON_ID')) FROM SYS.USER$ U
, SYS.OBJ$ O
, SYS.X$DIR D WHERE U.USER# = O.OWNER#
AND O.OBJ# = D.OBJ#