My Oracle Support Banner

Error When Using External Tables Loading Special Characters. Eg "É" In "MÉXico" (Doc ID 742653.1)

Last updated on NOVEMBER 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Using external table to load data into the database.
Recieve the following error at the time of create :

KUP-04021: field formatting error for field <FIELD>
KUP-04023: field start is after end of record
KUP-04101: record 2 rejected in file <DIR>/<FILENAME>.txt

Data file to be loaded has special characters like "É" In "MÉXico"

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
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.