My Oracle Support Banner

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

Last updated on JANUARY 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Generic UNIX


Select from external table giving below errors :

select count(*) from EXT_SCA ;

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file SAGESS_GTA_H_TRAV.DAT in SCA not found

>>> When add "other" rx privileges on the directory /transfert/sca, the query is successfull.

rs16:/transfert/sca# 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 SAGESS_GTA_H_TRAV.DAT

For security reasons, adding "other" rx privilges on the directory is not possible


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.