oracle修改字符集
查询oracle server端字符集
select userenv('language') from dual
SQL>shutdown immediate ; // 关闭数据库
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK; //跳过超子集检测
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP
oracle修改字符集
最新推荐文章于 2021-07-20 14:32:09 发布