table partially imported due to trigger fired
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