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 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

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.

Changes

The External file is kept in the NFS Storage

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


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