I think your trigger is referring to the table in different schema... On 10/1/05, Chirag DBA <chiragdba@xxxxxxxxx> wrote: > > 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... >