oracle 19c 单实例修改字符集

最新推荐文章于 2024-05-03 11:47:20 发布

番茄你个西红4

最新推荐文章于 2024-05-03 11:47:20 发布

阅读量794

点赞数 1

文章标签：数据库 oracle

本文链接：https://blog.csdn.net/qq_21608393/article/details/129705747

版权

SELECT * FROM NLS_DATABASE_PARAMETERS p where p.PARAMETER='NLS_CHARACTERSET';
SELECT USERENV('language') FROM DUAL;

shutdown immediate;
startup mount;
ALTER SESSION SET SQL_TRACE=TRUE;
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;
RROR at line 1:
　　ORA-12712: new character set must be a superset of old character set

ALTER DATABASE character set INTERNAL_USE zhs16gbk;
ALTER SESSION SET SQL_TRACE=FALSE;
shutdown immediate;
STARTUP
select NLS_CHARACTERSET from nls_database_parameters;