oracle 编码修改

最新推荐文章于 2023-03-03 16:14:58 发布

iteye_6961

最新推荐文章于 2023-03-03 16:14:58 发布

阅读量73

点赞数

分类专栏： oracle 文章标签： oracle 编码修改

本文链接：https://blog.csdn.net/iteye_6961/article/details/82480672

版权

oracle 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 499125840 bytes
Database Buffers 343932928 bytes
Redo Buffers 5132288 bytes
Database mounted.
SQL> alter system enable restricted session;

System altered.

SQL> alter system set job_queue_processes=0;

System altered.

SQL> alter system set aq_tm_processes=0;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database character set internal_use UTF8 ;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

select userenv('language') from dual ---查看编码

oraacle clinet 编码设置

打开注册表HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1
将NLS_LANG 修改为
select userenv('language') from dual 查询的值