Which Directory Permissions is required For External Tables in Unix
(Doc ID 2499267.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterGeneric UNIX
Symptoms
Select from external table giving below errors :
select count(*) from EXT_TEST ;
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file TEST.DAT in TEST not found
>>> When add "other" rx privileges on the directory /transfert/test, the query is successfull.
rs16:/transfert/test# ls -ail
total 83208
12288 drwxrwxr-x 2 oracle exploit 256 Oct 16 15:51 .
2 drwxrwxr-x 6 exploit exploit 256 Oct 16 15:49 ..
12289 -rw-r--r-- 1 exploit exploit 42600000 Oct 16 15:51 TEST.DAT
rs16:/transfert/test#
For security reasons, adding "other" rx privilges on the directory is not possible
Changes
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 |
Changes |
Cause |
Solution |
References |