My Oracle Support Banner

External Table Error ORA-29400 KUP-04004 By Accessing Empty File On NFS Sever (Doc ID 2455361.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.2]
Information in this document applies to any platform.


The error ORA-29400 & KUP-04004 received when accessing the External Table when the file resides on the NFS Storage.

The error occurs on an empty file and the same works fine when the file contains a line on a NFS filesystem.

There is no error when the file is on the Local filesystem on both empty and non empty file.


The External file is kept in the NFS Storage


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.