How to fix the Oracle error SQL*Loader-00606: Object string in INTO TABLE clause is not a local table?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00606: Object string in INTO TABLE clause is not a local table with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error SQL*Loader-00606: Object string in INTO TABLE clause is not a local table ?

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

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.