今天在执行数据泵导入数据的时候出现了一下错误：
Import: Release 11.2.0.3.0 - Production on Thu Jun 22 11:50:51 2017
Copyright (c) 1982,2011,Oracle and/or its affiliates. All rights reserved.
;;;
………………
CREATE TABLE "JKDP_T"."TMP_BOOK_0419" ("靠1" VARCHAR2(200 BYTE),"靠 VARCHAR2(200 BYTE),"靠" VARCHAR2(200 BYTE),"靠
VARCHAR2(200 BYTE),"靠靠靠" VARCHAR2(200 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING STORAGE(INITIAL 2097152 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS 21474
ORA-39083: Object type TABLE:"JKDP_T"."TMP_BOOK_0419_ZJ" Failed to create with error:
ORA-00957: duplicate column name
Failing sql is:
CREATE TABLE "JKDP_T"."TMP_BOOK_0419_ZJ" ("靠1" VARCHAR2(200 BYTE),"
靠" VARCHAR2(200 BYTE),"靠靠靠" VARCHAR2(200 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255 NOCOMPRESS LOGGING STORAGE(INITIAL 2097152 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS
ORA-39083: Object type TABLE:"JKDP_T"."TMP_BOOK_0419_MH" Failed to create with error:
ORA-00957: duplicate column name
经查看，这些表的列名用的是中文，同时同时发现已导入的数据中文显示乱码，原来建库的时候使用了默认字符集 原文链接：https://www.f2er.com/oracle/208775.html
