错误描述：

IMP-00017: 由于 ORACLE 错误 1452, 以下语句失败:
 "CREATE UNIQUE INDEX "I_BD_BALATYPE_2" ON "BD_BALATYPE" ("PK_CORP" , "BALANN"
 "AME" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS "
 "1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "NNC_INDEX02" LOGGING"
IMP-00003: 遇到 ORACLE 错误 1452
ORA-01452: ？？ CREATE UNIQUE INDEX; ？？？？？？？？
IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败:
 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"I_BD_BALATYPE_2"',NULL,NULL,NULL,7"
 ",1,7,1,1,1,0,6); END;"
IMP-00003: 遇到 ORACLE 错误 20000
ORA-20000: INDEX "WDQH"."I_BD_BALATYPE_2" does not exist or insufficient privileges
ORA-06512: ？ "SYS.DBMS_STATS", line 3007
ORA-06512: ？ "SYS.DBMS_STATS", line 7865
ORA-06512: ？ line 1

原因：数据库创建时字符设置不正确

查看字符类型

select userenv('language') from dual;

select * from nls_database_parameters

应该设置为：ZHS16GBK

执行以命令：

SQL> shutdown immediate;

SQL> startup mount

SQL> alter system enable restricted session;

SQL> alter system set job_queue_processes=0;

SQL> alter system set aq_tm_processes=0;

SQL> alter database open;

SQL> alter database character set ZHS16GBK;

ERROR at line 1:
ORA-12712: new character set must be a superset of old character set

报错了

强制执行

SQL> alter database character set INTERNAL_USE ZHS16GBK;

SQL> shutdown immediate;

SQL> startup

OK,再次导入，成功。