Import report error when using ignore=y
Date: Mon, 23 Apr 2001 11:13:52 -0400
Message-ID: <3AE446B0.36DE571F_at_hrb.com>
[Quoted] 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 Received on Mon Apr 23 2001 - 17:13:52 CEST