External Tables Are Not Accessible When The Path Contains A Link
(Doc ID 1396021.1)
Last updated on JANUARY 07, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2.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
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
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
| Symptoms |
| Cause |
| Solution |
| References |