From: "TC" Newsgroups: comp.databases.oracle References: Subject: Re: 8.1.7 Import Fails Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: NNTP-Posting-Host: 12.250.123.140 X-Complaints-To: abuse@attbi.com X-Trace: sccrnsc03 1054906648 12.250.123.140 (Fri, 06 Jun 2003 13:37:28 GMT) NNTP-Posting-Date: Fri, 06 Jun 2003 13:37:28 GMT Organization: AT&T Broadband Date: Fri, 06 Jun 2003 13:37:28 GMT 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" wrote in message news:d25b2692.0306051112.2f3dd7b2@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.