数据库更改字符集

1）然后查看数据库字符集设置

select * from nls_database_parameters where parameter ='NLS_CHARACTERSET';

 

 

2）步骤：执行以下命令（命令行窗口）

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 character set AL32UTF8;

（如果报错，改用：SQL> ALTER DATABASE character set INTERNAL_USE AL32UTF8;）

SQL>shutdown immediate;

SQL>startup;