4 Replies Latest reply on Apr 30, 2014 1:50 PM by Richard Harrison .

    ORACLE error 942 encountered

    GauravSontakke

      Hi ,

      I have exported data from database version 11.2.1.0 and I am trying to import that dump on another machine . Oracle version of machine where I am installing oracle 11.1.0.6.0. But while importing constraints and indexes I am getting following error "table or view does not exist" for all the tables but when I manually checked tables do exist in that user .

       

      IMP-00017: following statement failed with ORACLE error 942:

      "ALTER TABLE "AD_WORKBENCH" ADD CONSTRAINT "ADCOLOR_ADWORKBENCH" FOREIGN KEY"

      " ("AD_COLOR_ID") REFERENCES "AD_COLOR" ("AD_COLOR_ID") ENABLE NOVALIDATE"

      IMP-00003: ORACLE error 942 encountered

      ORA-00942: table or view does not exist

      IMP-00017: following statement failed with ORACLE error 942:

      "ALTER TABLE "AD_WINDOW" ADD CONSTRAINT "ADCOLOR_ADWINDOW" FOREIGN KEY ("AD_"

      "COLOR_ID") REFERENCES "AD_COLOR" ("AD_COLOR_ID") ENABLE NOVALIDATE"

       

       

      For export I used following command :  exp username/password file=ExpDat.dmp

       

      For Import I am using : imp username/password file=filename.dmp full=y

       

       

      What could be the possible reason ? Please help me out .

       

      Thank you for help in advance.