经查询,这个是由于字符集设置的不是gbk的,导致导入时遇到中文字符出现的问题,
1.打开cmd
2.输入sqlplus
4.查看版本号:select userenv('language') from dual;注意带上分好
查询字符集结果有可能是AL32UTF8
更改字符集为ZHS16GBK
cmd命令
sql>sqlplus /nolog;
sql> conn /as sysdba;
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 INTERNAL_USE ZHS16GBK;
sql> ALTER DATABASE CHARACTER SET ZHS16GBK;
sql>shutdown immediate;
sql>startup;