How to fix the Oracle error SQL*Loader-00656: position specification for column string is not allowed in external table loads?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00656: position specification for column string is not allowed in external table loads with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00656: position specification for column string is not allowed in external table loads

Reason for the Error SQL*Loader-00656: position specification for column string is not allowed in external table loads

Use of a position specification was present in an external table load.

How to fix the Error SQL*Loader-00656: position specification for column string is not allowed in external table loads ?

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

Either remove the position specification, change the position specification to a field name reference, use direct path, or use conventional path.