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.