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


i have oracle dump (.dmp) want import local oracle instance. when full import, fails

imp-00033: warning: table not found in export file.

some facts:

  • using imp system/pass ignore=yes tables=(t1,t2,t3,..)
  • export successful (according log)
  • export done in oracle database 10g release 10.1.0.4.0, import done in oracle database 11g express edition release 11.2.0.2.0
  • when show=y ddl shown tables on list
  • before printing 00033 warning, there imp-00009: abnormal end of export file
  • when full import (without specifying table names), there sorts of errors, including

    "imp-00003: oracle error 1435 encountered",
    "ora-01435: user not exist",
    "ora-01031: insufficient privileges".

these errors not appear when specify table names.

how import?

if got imp-00009: abnormal end of export file means import file not have expected format, or worse incomplete! (but in last case not able import specifying table names).

since database versions different, should make sure import script specifies format of incoming data version=10.1.0 in imp command


Comments

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -