oracle11g数据库怎么改编码格式

首先查看oracle数据库的编码:

select userenv(‘language’) from dual;  

SQL> select * from nls_database_parameters where parameter ='NLS_CHARACTERSET';
修改字符集编码(这会对数据库的数据有直接的影响,谨慎操作):
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>shutdown immediate;
SQL> startup