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

Thread: IMP-00019: row rejected due to ORACLE error 1

  1. #1
    Join Date
    Jan 2001
    Posts
    91

    Angry

    I'm getting this message when importin from a dump file. I using Oracle 8.1.6 for NT.

    I checked metalinks website I didn't find anything specific any info will be helpful

    here's the error


    IMP-00019: row rejected due to ORACLE error 1
    IMP-00003: ORACLE error 1 encountered
    ORA-00001: unique constraint (TIMSS.ACCTNO_PK) violated
    Column : 99-999-99999-11101-0000
    Column : A
    Column : ORDER ENTRY - INVENTORY ACCOUNT
    Column : N
    Column : 24-JUL-1999:14:17:06
    Column : DATACONV
    Column : 17-AUG-1999:09:54:53
    Column : WENDY
    Column : 275453




  2. #2
    Join Date
    Feb 2001
    Posts
    15
    if the table that you are importing was empty before you beginning you probably created or updated a unique constraints and that constraint is rejecting duplicated registers.
    If the table was not empty you must empty it.

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