今天做数据迁移导入,在另外一台服务器上新建立数据库,建好相同的用户和相同的表空间后导入从生产上备份的用户的数据库,最后显示导入成功,但有警告,中间的过程中出现如下错误提示,请高手解惑一下,因为怕到时候搬迁过来影响以后的正常工作:
. . importing table "MEMBER" 44121 rows imported
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "MEMBER" ADD UNIQUE ("USERNAME") USING INDEX PCTFREE 10 INITRA"
"NS 2 MAXTRANS 255 STORAGE(INITIAL 2097152 FREELISTS 1 FREELIST GROUPS 1 BUF"
"FER_POOL DEFAULT) TABLESPACE "MEMBERSTORE" LOGGING ENABLE"
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (USER_STORE.SYS_C005525) - duplicate keys found
. . importing table "MEMBERINFO" 44121 rows imported
. . importing table "MEMBER" 44121 rows imported
IMP-00017: following statement failed with ORACLE error 2299:
"ALTER TABLE "MEMBER" ADD UNIQUE ("USERNAME") USING INDEX PCTFREE 10 INITRA"
"NS 2 MAXTRANS 255 STORAGE(INITIAL 2097152 FREELISTS 1 FREELIST GROUPS 1 BUF"
"FER_POOL DEFAULT) TABLESPACE "MEMBERSTORE" LOGGING ENABLE"
IMP-00003: ORACLE error 2299 encountered
ORA-02299: cannot validate (USER_STORE.SYS_C005525) - duplicate keys found
. . importing table "MEMBERINFO" 44121 rows imported
你可以先把表建立好,再导入试试看