Problem when importing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Problem when importing

  1. #1
    Join Date
    Jan 2002
    Posts
    96
    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

  2. #2
    Join Date
    Jul 2002
    Posts
    132
    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.

  3. #3
    Join Date
    Jan 2002
    Posts
    96
    That's the thing I disabled all the triggers, and i still get the error message. What now?

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Its not so much disabling the triggers as disabling all constraints.

  5. #5
    Join Date
    Jul 2002
    Posts
    132
    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

  6. #6
    Join Date
    Jan 2002
    Posts
    96
    lemme give it a bash

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width