Warnings while importing Work repository into a new database.
735763Dec 7 2010 — edited Dec 9 2010Hi ,
I am trying to move the ODI repositories from DEV to TEST, both or standard Oracle DB 11g R2 databases.
I have exported the existing ODI WORK & MASTER repositories into dump files using the Oracle EXPORT command:
Privilages:
Both masterrep and workrep has DBA privilages on the database.
EXP masterrep/masterrep@orcl file=C:\uat712\masterrep071210.dmp OWNER=masterrep
EXP workrep/workrep@orcl file=C:\uat712\workrep071210.dmp OWNER=workrep
When I try to import the work repository I get the below error:
IMPORT COMMAND:
-----------------------------
IMP workrep/workrep@orcl file=v:\workrep071210.dmp FROMUSER=workrep TOUSER=workrep
ERROR
---------
. . importing table "SNP_VAR_SESS" 12 rows imported
IMP-00017: following statement failed with ORACLE error 942:
"ALTER TABLE "SNP_SCEN" ADD CONSTRAINT "FK_SCEN_FOLDER" FOREIGN KEY ("I_SCEN"
"_FOLDER") REFERENCES "SNP_SCEN_FOLDER" ("I_SCEN_FOLDER") 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 "SNP_TXT_CROSSR" ADD CONSTRAINT "FK_TXT_CROSSR_UFUN" FOREIGN KE"
"Y ("I_UFUNC") REFERENCES "SNP_UFUNC" ("I_UFUNC") 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 "SNP_TXT_CROSSR" ADD CONSTRAINT "FK_TXT_CROSSR5" FOREIGN KEY (""
"SEQ_ID") REFERENCES "SNP_SEQUENCE" ("SEQ_ID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 2430:
"ALTER TABLE "SNP_SCEN" ENABLE CONSTRAINT "FK_SCEN_FOLDER""
IMP-00017: following statement failed with ORACLE error 2430:
"ALTER TABLE "SNP_TXT_CROSSR" ENABLE CONSTRAINT "FK_TXT_CROSSR_UFUN""
IMP-00017: following statement failed with ORACLE error 2430:
"ALTER TABLE "SNP_TXT_CROSSR" ENABLE CONSTRAINT "FK_TXT_CROSSR5""
Import terminated successfully with warnings.
Not sure what the issue could be. Appreciate your comments and suggestions.
Best Regards
B