Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table partially imported due to trigger fired

327464Jun 28 2006
Hi,

I encounter following error when import data from another database on schema level:
-----------------------------------------------------------------------------------------------------
IMP-00058: ORACLE error 4091 encountered
ORA-04091: table OSIBANK.ACCTFILETYPSOURCEID is mutating, trigger/function may n
ot see it
ORA-06512: at "OSIBANK.TRIG_ACCTFILETYPSID_NODUPS", line 10
ORA-04088: error during execution of trigger 'OSIBANK.TRIG_ACCTFILETYPSID_NODUPS
'
IMP-00018: partial import of previous table completed: 1905 rows imported
--------------------------------------------------------------------------------------------------------
When the import finished with this error, I disabled constraints of the table and the trigger, truncate the table, then import on table level, finally enable constraints and trigger, it works.
Now my question is: is there any more convenient way? If there are many tables partially import due to trigger fired during import, above method is very time consuming.

Thanks in advance.

Richard
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2006
Added on Jun 28 2006
0 comments
312 views