How to fix the Oracle error SQL*Loader-00420: unsupported datatype conversion requested for column string in table string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00420: unsupported datatype conversion requested for column string in table string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00420: unsupported datatype conversion requested for column string in table string

Reason for the Error SQL*Loader-00420: unsupported datatype conversion requested for column string in table string

The colummn needs to have it’s data converted to another datatype before loading the data. The required conversion cannot be done by sqlldr.

How to fix the Error SQL*Loader-00420: unsupported datatype conversion requested for column string in table string ?

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

Verify that the correct datatype was specified for the column.