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 184.108.40.206 to 220.127.116.11.0 [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
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 18.104.22.168 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