VIEW: SYS.DBA_EXTERNAL_LOCATIONS

Source

View Text - Preformatted

select u.name, o.name, xl.name, 'SYS', nvl(xl.dir, xt.default_dir)
from sys.external_location$ xl, sys.user$ u, sys.obj$ o, sys.external_tab$ xt
where o.owner# = u.user#
  and o.obj# = xl.obj#
  and o.obj# = xt.obj#

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, XL.NAME
, 'SYS'
, NVL(XL.DIR
, XT.DEFAULT_DIR) FROM SYS.EXTERNAL_LOCATION$ XL
, SYS.USER$ U
, SYS.OBJ$ O
, SYS.EXTERNAL_TAB$ XT WHERE O.OWNER# = U.USER#
AND O.OBJ# = XL.OBJ#
AND O.OBJ# = XT.OBJ#