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

Thread: Imprt (2291)

  1. #1
    Join Date
    Jul 2001
    Posts
    181
    Hi,

    I did an export but found some extents to be too large for the tablspaces ther were going too, therfore I used an indexfile to precreate the tables, so I have all the table precreated with no data, now I try to use the original import with ignore=y, howvever it fails with the following errors

    IMP-00019: row rejected due to ORACLE error 2291
    IMP-00003: ORACLE error 2291 encountered
    ORA-02291: integrity constraint (TEST.R_638) violated - parent key not found

    I have tried the import with constraints=n

    Thanks in advance...

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    When you make an export use CONSISTENT=Y clause
    Best wishes!
    Dmitri

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