HomeOracleOracle Error ORA-39221: Specifying data filters is invalid when dumpfiles do not contain table data.

Oracle Error ORA-39221: Specifying data filters is invalid when dumpfiles do not contain table data.

Oracle Error Message

ORA-39221: Specifying data filters is invalid when dumpfiles do not contain table data.

Reason for the Error

A data filter was supplied for an import job, but the dumpfile does not contain any table data. The export command created a dumpfile with metadata only. No table data was included. From the command line, data filters can be specified by the CONTENT, SAMPLE and QUERY parameters.

Solution

Do not restrict data handling on jobs that cannot support data filtering.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...