昨天我在将数据导入到oracle11g中时,报了如图一所示错误;后来发现是在安装oracle数据库时,字符集没有选对,百度了一些oracle数据库更改字符集的方法;成功解决问题。下面为更改oracle字符集的步骤:
conn /as sysdba
shutdown immediate;
startup mount
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
alter database open;
ALTER DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
shutdown immediate;
startup
--最后查看oracle数据库字符集是否更改正确
select userenv ('language') from dual;