Oracle: 更改Oracle字符集从UTF-8变成16GBK

最新推荐文章于 2024-07-18 19:08:51 发布

EchoYa!

最新推荐文章于 2024-07-18 19:08:51 发布

阅读量446

点赞数 5

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/weixin_45903807/article/details/139354471

版权

# 关闭数据库
shut immediate


# 以mount打开
startup mount;

# 设置session
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;


# 启动数据库
alter database open;

# 修改字符集
ALTER DATABASE CHARACTER SET ZHS16GBK;

# 可能会遇到的错误：ORA-12712: new character set must be a superset of old character set

# 解决办法
ALTER DATABASE character set INTERNAL_USE ZHS16GBK;


# 关闭
shut immediate

# 重启
startup;

# 查看当前字符集
SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
SELECT USERENV('language') FROM DUAL;