How to fix the Oracle error SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number)?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number)

Reason for the Error SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number)

The given column with the given form of use does not have the same character set ID as a previous column with the same form of use.

How to fix the Error SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number) ?

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

This should not happen. Contact ORACLE support and supply the following information: DDL for the table being loaded, and the SQL*Loader control file. ADDED in 8.1