How to fix the Oracle error KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.?

In this post, you’ll learn more about the Oracle ErrorKUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column. ?

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

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.