Oracle Error ORA-39246: cannot locate master table within provided dump files

Oracle Error Message

ORA-39246: cannot locate master table within provided dump files

Reason for the Error

A Data Pump IMPORT or SQL_FILE operation was being performed but not all of the files from the Data Pump export dump file set were included. In particular, the dump file containing the export job’s master table was not provided.

Solution

Check the export log file and make sure all of the files that were exported are included in the current job.

Share:

Leave A Reply

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

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...