Import and export of DMP files between Oracle versions the DMP exported from Oracle 11g is imported to a 10g Database (imp-00010: it is not a valid export file, and the header verification fails)

The following problems are frequently encountered during data migration:

1. If the exported file is not valid, the header verification fails;

2. EXP-00056: Oracle error 6550
ORA-06550: Line 1, column 41:
PLS-00302: component 'set _ no_outlines 'must be declared
ORA-06550: Line 1, column 15:
PL/SQL: Statement ignored
EXP-00000: Export termination failed

About import and export:

1. The exp command on the client must be consistent with the Oracle version on the server when the export is executed;

2. Use expdp and impdp for Oracle10g or above

When you import a later version of oralce to a later version of DMP, you may encounter a similar error such as "invalid export file, header Verification Failed". You can use a tool to modify the DMP file.

For details, see the DMP imported from Oracle 11G to the 10g Database (imp-00010: the exported file is not valid and the header verification fails)

 

Export error:

When executing the exp Export command is often encountered similar to the EXP-00056: encountered Oracle error 6550, this is generally the execution of the command client oralce version does not match the server, you can change the client to solve.