Import errors 10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import errors 10g

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    Import errors 10g

    Hi ,
    I am getting the following errors during imort into 10g from 8174 on Linux Red hat.

    . . importing table "PIPELINE"
    IMP-00058: ORACLE error 4098 encountered
    ORA-04098: trigger 'CSSOWNR.AFTER_PIPELINE_TX_STATUS_ROW' is invalid and failed re-validation
    . . importing table "PIPELINE_PARTIES"
    IMP-00058: ORACLE error 20000 encountered
    ORA-20000: insert into pipeline_parties failed for pipeline_tx_id: 10096967028 ORA-01403: no data found
    ORA-06512: at "CSSOWNR.TIB_PIPELINE_PARTIES", line 36
    ORA-04088: error during execution of trigger 'CSSOWNR.TIB_PIPELINE_PARTIES'
    . . importing table "PIPELINE_XREF"

    Please let me know.

    Thanks in advance.

  2. #2
    Join Date
    Dec 2007
    Posts
    55
    Disable the triggers , re-import and then enable it back.

    Hope this helps.

    Regards

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