把以前vm中的oracle数据库用exp->imp的方式整个迁移到了新的实机服务器中,用户名的属性可能有变更。但在新的服务器中使用sqlldr向某一表(与vm中的原始表结构完全一致)中以append方式导入数据时出现如下错误(vm中的原始表并不出现此错误):
Record 1: Rejected - Error on table T1.
ORA-00001: unique constraint (ABC.PK_T1) violated
Record 2: Rejected - Error on table T1.
ORA-00001: unique constraint (ABC.PK_T1) violated
....
哪位高手指点下原因,不胜感激!!!!!!!!!!!!
Record 1: Rejected - Error on table T1.
ORA-00001: unique constraint (ABC.PK_T1) violated
Record 2: Rejected - Error on table T1.
ORA-00001: unique constraint (ABC.PK_T1) violated
....
哪位高手指点下原因,不胜感激!!!!!!!!!!!!
CREATE UNIQUE INDEX ABC.PK_T1
ON ABC.T1(ID, COUNT)