导入数据报错ORA-00904 ORA-32588

Alan1921

于 2020-04-16 21:35:02 发布

阅读量1.8k

点赞数

分类专栏： oracle 文章标签： oracle 数据库导入数据 ORA-00904 ORA-32588

本文链接：https://blog.csdn.net/Alan1921/article/details/105566076

版权

本文介绍了在Oracle数据库中遇到ORA-00904和ORA-32588错误的解决过程。通过检查错误定义、分析表结构差异，发现问题出在导入数据的表结构与目标数据库的同名表结构不一致，存在新增字段。解决方案是删除目标表的新增字段，重新导出数据。

摘要由CSDN通过智能技术生成

问题登场

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

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing XXZX_QUERY's objects into JHK
. importing XXZX_QUERY's objects into JHK
. . importing table                         "IY01"
IMP-00058: ORACLE error 904 encountered
ORA-00904: "E00001": invalid identifier
IMP-00017: following statement failed with ORACLE error 32588:
 "ALTER TABLE "IY01" ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS"
IMP-00003: ORACLE error 32588 encountered
ORA-32588: supplemental logging attribute foreign key exists
IMP-00017: following statement failed with ORACLE error 32588:
 "ALTER TABLE "IY01" ADD SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS"
IMP-00003: ORACLE error 32588 encountered
ORA-32588: supplemental logging attribute unique key exists
IMP-00017: following statement failed with ORACLE error 32588:
 "ALTER TABLE &