How to fix the Oracle error ORA-31655: no data or metadata objects selected for job?

In this post, you’ll learn more about the Oracle ErrorORA-31655: no data or metadata objects selected for job with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31655: no data or metadata objects selected for job

Reason for the Error ORA-31655: no data or metadata objects selected for job

After the job parameters and filters were applied, the job specified by the user did not reference any objects.

How to fix the Error ORA-31655: no data or metadata objects selected for job ?

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

Verify that the mode of the job specified objects to be moved. For command line clients, verify that the INCLUDE, EXCLUDE and CONTENT parameters were correctly set. For DBMS_DATAPUMP API users, verify that the metadata filters, data filters, and parameters that were supplied on the job were correctly set.

Tags :

Leave Your Comment