修改Oracle数据库的字符集(UTF8→ZHS16GBK)
1. C:\Users\Administrator>sqlplus /nolog
2.以sysdba的身份登录上去
SQL> conn sys/root as sysdba
3.以mount模式启动数据库
SQL>startup mount
4.设置session
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
5.启动数据库
SQL>alter database open;
6.修改字符集
SQL>ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
7.关闭,重新启动
SQL>shutdown immediate;
SQL>startup
--查询数据信息
select * from v$nls_parameters;
1. C:\Users\Administrator>sqlplus /nolog
2.以sysdba的身份登录上去
SQL> conn sys/root as sysdba
3.以mount模式启动数据库
SQL>startup mount
4.设置session
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
5.启动数据库
SQL>alter database open;
6.修改字符集
SQL>ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
7.关闭,重新启动
SQL>shutdown immediate;
SQL>startup
--查询数据信息
select * from v$nls_parameters;