Problem when importing

[charlton]

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?

Thanks

[soniaarora]

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.

[charlton]

That's the thing I disabled all the triggers, and i still get the error message. What now?

[JMac]

Its not so much disabling the triggers as disabling all constraints.

[soniaarora]

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

[charlton]

lemme give it a bash