RE: export error

From: Milen Kulev <makulev_at_gmx.net>
Date: Sun, 2 Oct 2005 10:38:01 +0200
Message-ID: <000401c5c72c$9c04b5d0$0a00a8c0@trivadis.com>

Hi Chirag,
perhaps you are dealing (indirect) with snapshots /snapshots log (See Note: 294625.1 )  

" Snapshots, snapshot logs, and related items are exported with the schema name explicitly given in the DDL statements; therefore, snapshots and their related items cannot be imported into a different schema.

If you attempt to use FROMUSER and TOUSER to import snapshot data, an error will be written to the Import log file and the items will not be imported. "  

HTH.
MILEN -----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sami Seerangan Sent: Saturday, October 01, 2005 8:16 PM To: chiragdba_at_gmail.com
Cc: Oracle-L Freelists
Subject: 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

Received on Sun Oct 02 2005 - 03:40:09 CDT