Oracle Error SQL*Loader-00606: Object string in INTO TABLE clause is not a local table

Oracle Error Message

SQL*Loader-00606: Object string in INTO TABLE clause is not a local table

Reason for the Error

The synonym specified in the INTO TABLE clause in the SQL*Loader control file specifies a remote object via a database link. Only a synonym for an existing local table can be specified in the INTO TABLE clause.

Solution

Ensure that a local table name or a synonym for a local table is fully specified in the INTO TABLE clause. The table must already exist.