IMP-00017: following statement failed with ORACLE error 2264:
"ALTER TABLE "CASHFLOWS" ADD CONSTRAINT "CC_CASHFLOWS_ACCT_NUM_NN" CHECK (AC"
"CT_NUM IS NOT NULL) ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
此问题怎么解决呢??我用的是imp ftp/ftp@ftp214 file=ftp_objects.dmp log=imp_ftp_objects.log ignore=y statistics=none fromuser=ftp touser=ftp
"ALTER TABLE "CASHFLOWS" ADD CONSTRAINT "CC_CASHFLOWS_ACCT_NUM_NN" CHECK (AC"
"CT_NUM IS NOT NULL) ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint
此问题怎么解决呢??我用的是imp ftp/ftp@ftp214 file=ftp_objects.dmp log=imp_ftp_objects.log ignore=y statistics=none fromuser=ftp touser=ftp
约束已存在,楼主把表约束drop掉在导试试..
这里最好把原来的contraints干掉。然后导入,顺便,你这里这个表,是已经存在的表吗,还是导入时生成的新表。