Oracle Error KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

Oracle Error Message

KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

Reason for the Error

A query of an external table of type ORACLE_DATAPUMP tried to reference the ROWID column. The ORACLE_DATAPUMP access driver does not support ROWIDs.

Solution

Remove the ROWID from the query. If that is not possible, create a table in the database with the same columns as the external table, copy the data from the external table into the newly created table, and use that new table for the query.