Re: 8.1.7 Import Fails
Date: Fri, 06 Jun 2003 13:37:28 GMT
Message-ID: <sO0Ea.885626$Zo.201260_at_sccrnsc03>
ignore mean "ignore create errors", and is strictly related to DDLs
the row in question is supposed to be a foreign key. Possibly the parent row has been deleted
if this is a self referencing constraint, it may mean that this row is getting loaded before its parent row
you may want to disable the contraint and try importing, but remember that may cause issues with integrity of your data
//tc
"Yvonne Dishon" <dishonty_at_seidata.com> wrote in message
news: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 Fri Jun 06 2003 - 15:37:28 CEST