1

Topic: KUP-04027

There is a table:
SQL> desc AUDIT_2PC_TAB_WORKING
Name Null? Type
----------------------------------------- -------- ----------------------------
TEXT VARCHAR2 (300)
At reversal to the table there is an error:
SQL> select count (*) from AUDIT_2PC_TAB_WORKING;
select count (*) from AUDIT_2PC_TAB_WORKING
*
ERROR at line 1:
ORA-29913: erreur d'excution de l'appel ODCIEXTTABLEFETCH
ORA-29400: erreur de cartouche de donnes
KUP-04027: file name check failed:/usr/bin/sh
Under the document Doc ID 1274653.1 , fulfilled request:
undefine owner
undefine table_pattern
select el.table_name, el.owner, dir.directory_path || ' / ' || dir.directory_name "path"
from dba_external_locations el
, dba_directories dir
where el.table_name like ' %&&table_pattern%'
and el.owner like ' %&&owner%'
and el.directory_owner = dir.owner
and el.directory_name = dir.directory_name
order by 1, 2;
TABLE_NAME OWNER path
------------------------------ ------------------------------ ----------------------------------------
AUDIT_2PC_TAB_WORKING SYS/tmp/AUDIT_2PC_DIR_WORKING
Folders/tmp/AUDIT_2PC_DIR_WORKING - are not present.
The Question - why appears an error: KUP-04027: file name check failed:/usr/bin/sh
What can be?

2

Re: KUP-04027

PREPROCESSOR

3

Re: KUP-04027

rinace;
Look DDL. It external table with a preprocessor.

4

Re: KUP-04027

env;
Thanks for .
Understood