因字符集设置错误导致imp导入错误的解决方法

因字符集设置错误导致imp导入错误的解决方法

IMP-00017: following statement failed with ORACLE error 1452:
 "CREATE UNIQUE INDEX "BALANCE_TYPE_NAME" ON "BALANCE_TYPE" ("BALANCE_TYPE_NA"
 "ME" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1"
 " FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TWB2B" LOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 20000:
 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"BALANCE_TYPE_NAME"',NULL,NULL,NULL"
 ",6,1,6,1,1,1,0,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "TCLKT"."BALANCE_TYPE_NAME" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 2299:
 "ALTER TABLE "BALANCE_TYPE" ADD  CONSTRAINT "BALANCE_TYPE_NAME" UNIQUE ("BAL"
 "ANCE_TYPE_NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INI"
 "TIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T"
 "WB2B" LOGGING ENABLE "
IMP-00003: ORACLE error 2299 encountered

 

解决方法：
   查看源数据库字符集与目标数据库字符集对比，得出答案，
将数据库删除然后重新创建数据库，在创建数据库设置SGA,PGA的时候在字符集选项卡上设置
如：
源数据库字符集：ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
目标数据库应该也是： ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集

查看字符集语句：
col value format a30
set pages 400
select * from nls_database_parameters;