8.1.7 Import Fails

From: Yvonne Dishon <dishonty_at_seidata.com>
Date: 5 Jun 2003 12:12:14 -0700
Message-ID: <d25b2692.0306051112.2f3dd7b2_at_posting.google.com>

Platform is Redhat Linux and Oracle 8.1.7 4

I am trying to resize a table. Export the data, recreate the table in new size, then import data.
After exporting the table only and running import with ignore=y I keep getting the following errors and not all the rows load.

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

What am I missing? I thought ignore=y was for ignoring keys and constraints. Received on Thu Jun 05 2003 - 21:12:14 CEST

This message: [ Message body ]
Next message: philippe: "Re: SQL - filtering data based on AND condition"
Previous message: DiggidyMack69: "Auditing Question"
Next in thread: TC: "Re: 8.1.7 Import Fails"
Reply: TC: "Re: 8.1.7 Import Fails"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message