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 11.2.0.2 to 11.2.0.2.0 [Release 11.2]
Generic Windows

Symptoms


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 11.2.0.2 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. 

Cause

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