Hi there DBA Guru's
I need your help. When doing a imp on a table I receive the following error
IMP-00058: ORACLE error 20087 encountered
ORA-20087: No master billing account for this entry. Please check bill_account_id
ORA-06512: at "IPACSEC.CUSTOMERS_INSERT_TRIG", line 18
ORA-04088: error during execution of trigger 'IPACSEC.CUSTOMERS_INSERT_TRIG'
IMP-00028: partial import of previous table rolled back: 89999 rows rolled back
IMP-00017: following statement failed with ORACLE error 1917:
What Is wrong? And how do I fix it? Is there someway I can make it commit before it rollsback?
As per the error, there seems to be foreign key violation.
Check what the trigger CUSTOMERS_INSERT_TRIG does in IPACSEC schema. I am sure it is trying to insert a customer which does not have a corresponding bill_account_id in master table. And so the error.
There is no point in commiting data which violates a rule. Nevertheless, u can disable to trigger to go ahead and then import again.
That's the thing I disabled all the triggers, and i still get the error message. What now?
Its not so much disabling the triggers as disabling all constraints.
If u r disabling the trigger, then Y is a row being tried to be inserted? Better disable the constraints if u want it this way
Click Here to Expand Forum to Full Width