- 查看原编码
select * from nls_database_parameters where parameter ='NLS_CHARACTERSET';
- 修改为AL32UTF8
$sqlplus /nolog
sql>conn /as sysdba;
sql>shutdown immediate;
mount数据库
sql>startup mount;
设置session
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 AL32UTF8;
关闭,重新启动
SQL>shutdown immediate;
SQL> startup