今天在执行数据泵导入数据的时候出现了一下错误:
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
经查看,这些表的列名用的是中文,同时同时发现已导入的数据中文显示乱码,原来建库的时候使用了默认字符集