Oracle数据库语言修改成UTF-8

select * from v$nls_parameters;

sqlplus "/ 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 NATIONAL CHARACTER SET INTERNAL_USE UTF8;

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

posted @ 2016-03-03 00:26  徐江华  阅读(724)  评论(0编辑  收藏  举报