We have received a dump file from our client.
While importing we are getting the following error
Connected to: Oracle8i Enterprise Edition Release 220.127.116.11.0 - Production
JServer Release 18.104.22.168.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,
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.
Click Here to Expand Forum to Full Width