I have done export from one schema and then export to another schema.
I specified the fromuser and touser but still it gave me error as table
does not exist.
Any idea?
bash-2.03$ imp userid=hermrep/hermrep file=exportdump.dmp fromuser=HERMES
touser=HERMREP
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "HERMREP"."TONPSIGNATURES_DEL" AFTER"
"DELETE ON "HERMES"."TONPSIGNATURES" FOR EACH ROW "
"BEGIN"
" if dbms_reputil.from_remote = true then"
" return;"
" end if;"
" "
" DELETE FROM ToNpSigElements"
" WHERE ToNpSigElements.PubId = :OLD.PubId"
" AND ToNpSigElements.PubSequence = :OLD.PubSequence"
" AND ToNpSigElements.SignatureName = :OLD.SignatureName;"
""
" DELETE FROM ToNpSigElemPPages"
" WHERE ToNpSigElemPPages.PubId = :OLD.PubId"
" AND ToNpSigElemPPages.PubSequence = :OLD.PubSequence"
" AND ToNpSigElemPPages.SignatureName = :OLD.SignatureName;"
"END ToNpSignatures_Del;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "HERMREP"."TONRLPAGES_DEL" AFTER"
"DELETE ON "HERMES"."TONRLPAGES" FOR EACH ROW "
"BEGIN"
" if dbms_reputil.from_remote = true then"
" return;"
" end if;"
" "
" DELETE FROM ToNrAds"
" WHERE ToNrAds.PubId = :OLD.PubId"
" AND ToNrAds.PubSequence = :OLD.PubSequence"
" AND ToNrAds.EditionId = :OLD.EditionId"
" AND ToNrAds.Page_level_id = :OLD.level_id"
" AND ToNrAds.PageName = :OLD.PageName;"
"END ToNrLPages_Del;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 01 2005 - 08:32:25 CDT
