Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-39140

Dump file "dump_file_name" belongs to job job_name.
  • dump_file_name: The name of the dump file.
  • job_name: The name of the job which owns the dump file.

Cause

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


Action

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.