While importing problem

[slatha]

Hi,

We have received a dump file from our client.

While importing we are getting the following error

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

Export file created by EXPORT:V08.01.05 via conventional path

Warning: the objects were exported by SYSTEM, not by you

import done in UTF8 character set and UTF8 NCHAR character set
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
. . importing table "AV_CLASS_MAP" 0 rows imported
. . importing table "AV_META_DATA" 212 rows imported
IMP-00017: following statement failed with ORACLE error 2261:
"ALTER TABLE "AV_META_DATA" ADD CONSTRAINT "UK_AV_META_DATA_0" UNIQUE ("OBJ"
"ECT_ID") ENABLE "
IMP-00003: ORACLE error 2261 encountered
ORA-02261: such unique or primary key already exists in the table
. . importing table "BANDWIDTH_DEF" 6 rows imported

The export is taken from 8.1.5 import utility. In 8.1.5 if we have a primary key on a column and if we try to create a unique constraint on the same column Oracle will give an error. If that is the case then how the above two statements came into the dump file while is creating an error while importing.

Thanks in advance,
Sreelatha

[oravijay]

Hi,

I think the database into which you are trying to import, has that table.
In these circumstances, you can try to import with IGNORE=Y option.

Vijay.