Oracle 修改字符编码

[b]登录Sqlplus，查看数据库编码[/b]

SQL> sqlplus /nolog  
SQL> conn / as sysdba
SQL> select * from v$nls_parameters;

[b]修改和设置数据库编码为ZHS16GBK[/b]

SQL> shutdown immediate; 
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter database open;
SQL> alter database character set internal_use ZHS16GBK;
SQL> shutdown immediate;
SQL> startup