Re: Import report error when using ignore=y

[Quoted] "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 Received on Mon Apr 23 2001 - 19:06:42 CEST