RE: export error
- From: "Milen Kulev" <makulev@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 2 Oct 2005 10:38:01 +0200
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sami Seerangan
Sent: Saturday, October 01, 2005 8:16 PM
To: chiragdba@xxxxxxxxx
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@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...
Other related posts:
