数据泵导入时报错ORA-39083: Object type TABLE:"JDIC"."CLCP" failed to create with error:

最新推荐文章于 2024-07-30 08:30:00 发布

jingleli21

最新推荐文章于 2024-07-30 08:30:00 发布

阅读量1.2k

点赞数

分类专栏：学习问题总结

本文链接：https://blog.csdn.net/jingleli21/article/details/45668795

版权

学习问题总结专栏收录该内容

36 篇文章 0 订阅

订阅专栏

ORA-39083: Object type TABLE:"JDIC"."CLCP" failed to create with error:

ORA-00957: duplicate column name

Failing sql is:

CREATE TABLE "JDIC"."CLCP" ("£¿£¿£¿£¿" VARCHAR2(50 BYTE), "£¿£¿£¿£¿" VARCHAR2(50 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USER_DATA"

ORA-39083: Object type TABLE:"JDIC"."CLCP1" failed to create with error:

ORA-00957: duplicate column name

Failing sql is:

CREATE TABLE "JDIC"."CLCP1" ("CPNO" VARCHAR2(8 BYTE), "£¿£¿ID" VARCHAR2(8 BYTE), "£¿£¿£¿£¿" VARCHAR2(50 BYTE), "£¿£¿£¿£¿" VARCHAR2(40 BYTE), "£¿£¿£¿£¿" VARCHAR2(16 BYTE), "£¿£¿£¿£¿" VARCHAR2(16 BYTE), "£¿£¿£¿£¿" VARCHAR2(2000 BYTE), "£¿£¿£¿" VARCHAR2(66 BYTE), "£¿£¿£¿" VARCHAR2(178 BYTE), "M£¿£¿£¿" VARCHAR2(2000 BYTE), "M£¿£¿£¿" VARCHAR2(2000 BYTE), "M£¿£¿" VARCHAR2(2000 BYTE), "M£¿£¿" VARCHAR2(2000 BYTE), "M£¿£¿£¿" VARCHAR2(20

经查找资料，查看到是ORA-00957产生的原因多数是因为字符集的问题，故重新安装数据库