In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00306: Token longer than max allowable length of number chars with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
SQL*Loader-00306: Token longer than max allowable length of number chars
Reason for the Error SQL*Loader-00306: Token longer than max allowable length of number chars
The SQL*Loader control file contains a single word or combination of characters (a token) that is longer than the maximum permissible value. The maximum possible value is shown. This error could result from missing spaces, so that multiple tokens are joined.
How to fix the Error SQL*Loader-00306: Token longer than max allowable length of number chars ?
You can fix this error in Oracle by following the below steps
Check that the proper SQL*Loader control file is being executed Separate tokens, if joined, or shorten the token.