Re: export error

I think your trigger is referring to the table in different schema...

On 10/1/05, Chirag DBA <chiragdba_at_gmail.com> 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...
>

--
http://www.freelists.org/webpage/oracle-l