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 UTF8;-----修改字符集为UTF8
SQL> shutdown immediate
SQL> startup
SQL> exit
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 UTF8;-----修改字符集为UTF8
SQL> shutdown immediate
SQL> startup
SQL> exit
---------------
alter system disable restricted session;
oracle编码格式从utf-8转换为GBK
http://www.cnblogs.com/qima/archive/2012/09/03/2669166.html
查看编码格式:
select userenv('language') from dual;
select * from nls_database_parameters