My Oracle Support Banner

External Tables Are Not Accessible When The Path Contains A Link (Doc ID 1396021.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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. 


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.