查看当前数据库字符集

select userenv('language') from dual;

USERENV('LANGUAGE')

------------------------------------

SIMPLIFIED CHINESE_CHINA.AL32UTF8

修改参数

alter system enable restricted session;

更改字符集，并跳过对超集的检查

alter database character set internal_use zhs16gbk;

重启数据库

shutdown immediate

startup

确认字符集已更改

select userenv('language') from dual;

USERENV('LANGUAGE')

--------------------------------------

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

ITPub博客

修改Oracle数据库字符集