External Tables Are Not Accessible When The Path Contains A Link

(Doc ID 1396021.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Generic Windows


Select from an external table fails with:


The directory exists on dba_directories and the users have permissions to read, write...BUT it is a link created with mklink:

mklink /D D:\empty_link d:\meta_data

Bundle patch 10 for was applied to fix bug 12640242 "11203_W2K8_ACFS:HIT KUP-04027 ERROR WHEN QUERY DATA FROM EXTERNAL TABLE ON ACFS" and DISABLE_DIRECTORY_LINK_CHECK parameter is used, but the issue is not solved. 


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms