DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jul 2005

    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
    Disable the triggers , re-import and then enable it back.

    Hope this helps.


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.