Clever Geek Handbook

Unable to import Oracle dump: IMP-00033: Warning: table not found in export file

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:

  • through imp system/pass ignore=yes tables=(t1,t2,t3,..)

  • export 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 displayed for all tables in the list
  • before printing warning 00033 exists IMP-00009: abnormal end of export file

  • when I do a full import (without specifying the table names) there are all sorts of errors, including

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

These errors are not shown when I specify the table names.

How to import?

+3


source to share


1 answer


If you receive it IMP-00009: abnormal end of export file

, it probably means that the import file is not in the expected format, or worse, it is incomplete! (but in this latter case, you won't be able to import pointers to table names).



Since the database versions are so different, you have to make sure that your import script defines the format of the incoming data with version=10.1.0

in your commandimp

+1


source






More articles:


All Articles