Re: Import report error when using ignore=y

Sybrand Bakker wrote:

> "Jeff Henderson" <jwh_at_hrb.com> wrote in message
> news:3AE446B0.36DE571F_at_hrb.com...
> > When doing an import (version 8.1.6.0.0) using ignore=y, I get the
> > following error:
> > IMP-00003: ORACLE error 2261 encountered
> > ORA-02261: such unique or primary key already exists in the table
> > Why is this creation error not ignored? This is a table mode import and
> > the table in question has both a unique key and a primary key, as well
> > as an index. It seems that the error is only reported on the unique key
> > (when I import a table with only a primary key, no error message is
> > produced). Why would it complain only about the unique key? The rows
> > are imported successfully just prior to the display of this error. The
> > unique key and primary key constraints do not reference any other
> > tables.
> >
> > Thanks,
> >
> > Jeff
> >
>
> Your error *is* ignored, as the import continues. With ignore=n the import
> would crash.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA

Thanks. I thought it was being ignored. Why then do some of the ignored errors get displayed while others do not? This particular import would also be ignoring a create table statement, a create index statement, and an alter table add primary key statement - yet there are no messages produced for those - only on the alter table add unique key statement.

Thanks,

Jeff Received on Mon Apr 23 2001 - 19:52:08 CEST