My Oracle Support Banner

ORACLE_LOADER External Table Access Driver Incorrectly Trims Whitespace (Doc ID 2654876.1)

Last updated on JULY 09, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 18.5.0.0.0 to 19.6.0.0.0 [Release 18 to 19]
Information in this document applies to any platform.

Symptoms

External table issue with tab terminator and LRTRIM in 18c & 19c

Incorrect column order in the external table.

The original file used for the external table is like

 

 

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.