SQL*Loader Express Mode Errors Out With "Column not found before end of logical record (use TRAILING NULLCOLS)"
(Doc ID 2250115.1)
Last updated on FEBRUARY 23, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
During the process of migration from MySQL data to Oracle using SQL*Loader express mode , the following error could be encountered:
Record 34: Rejected - Error on table <OWNER>.<TABLENAME>, column <COLUMNNAME>.
Column not found before end of logical record (use TRAILING NULLCOLS)
Column not found before end of logical record (use TRAILING NULLCOLS)
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 |