Which Directory Permissions is required For External Tables in Unix (Doc ID 2499267.1)

Last updated on JULY 20, 2024

Applies to:

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

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