Cannot import Oracle dump: IMP-00033: Warning: Table not found in export file

Question

I have an Oracle dump (.dmp) that I want to import into my local Oracle instance. But when I do a full import, it fails with

IMP-00033: Warning: Table not found in export file.

Some facts:

• using imp system/pass ignore=yes tables=(t1,t2,t3,..)
• export is successful (according to log)
• export is done in Oracle Database 10g Release 10.1.0.4.0, import is done in Oracle Database 11g Express Edition Release 11.2.0.2.0
• when I do show=y DDL is shown for all the tables on the list
• before printing the 00033 warning, there is IMP-00009: abnormal end of export file
• when I do a full import (without specifying table names), there are all sorts of errors, including

  "IMP-00003: ORACLE error 1435 encountered",
  "ORA-01435: user does not exist",
  "ORA-01031: insufficient privileges".

These errors do not appear when I specify the table names.

How to do the import?

Answer 1

If you got IMP-00009: abnormal end of export file this probably means that the import file do not have the expected format, or worse that it is incomplete! (but in that last case you would not be able to import specifying table names).

Since the database versions are so different, you should make sure that your import script specifies the format of incoming data with version=10.1.0 in your imp command