linux服务器上修改oracle数据库的字符集
linux服务器上以dba身份进入:sqlplus / 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 internal_use utf8;--此处举例子设置为utf8,可以根据自己要求设置:例如 ZHS16GBK;
shutdown immediate;
startup;
查看数据库字符集,看是否已经修改过来:
select userenv(‘language’) from dual;