Oracle12c修改字符集

管理员用户登录sqlplus,

依次执行以下命令:

shutdown immediate;
startup mount;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
shutdown immediate;
startup;

 

posted @ 2019-11-23 20:40  忘聊寒  阅读(972)  评论(0编辑  收藏  举报