VIEW: SYS.USER_EXTERNAL_LOCATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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