How to fix the Oracle error ORA-39140: dump file “string” belongs to job string?

In this post, you’ll learn more about the Oracle ErrorORA-39140: dump file “string” belongs to job string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39140: dump file “string” belongs to job string

Reason for the Error ORA-39140: dump file “string” belongs to job string

When a dump file set consists of multiple files, all files in the set must be specified for an import operation, and all files must have been produced by the same export job. One of the files provided does not belong to the original dump file set. For instance, it was created by a different export job than the other files.

How to fix the Error ORA-39140: dump file “string” belongs to job string ?

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

Remove the dump file indicated in the message and retry the import operation providing only the complete set of dump files created by a specific export job.