How to fix the Oracle error KUP-11003: bad data encountered while reading from file string?

In this post, you’ll learn more about the Oracle ErrorKUP-11003: bad data encountered while reading from file string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

KUP-11003: bad data encountered while reading from file string

Reason for the Error KUP-11003: bad data encountered while reading from file string

There was a datatype conversion error while attempting to convert the data in the data file to match the datatype of a column in the external table. The message that follows this one displays the name of the column and the start of the data for the column that could not be converted. The row containing the bad data is rejected and not included as a row in the external table.

How to fix the Error KUP-11003: bad data encountered while reading from file string ?

You can fix this error in Oracle by following the below steps

If the row containing the bad data should not be filtered out, then modify the definition of the external table so that the datatypes of the columns match the datatypes of the fields in the data file.