修改oracle编码格式

chucktan

于 2020-03-18 18:02:49 发布

阅读量162

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.csdn.net/chucktan/article/details/104950226

oracle 专栏收录该内容

1 篇文章

订阅专栏

–查看oracle数据库字符集
select userenv(‘language’) from dual;
–查询oracle数据库编码（注意NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET）
select * from nls_database_parameters;

–修改oracle数据库编码
–sqlplus 模式下
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter session set sql_trace=true;
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;
–修改注意NLS_CHARACTERSET
SQL> ALTER DATABASE character set INTERNAL_USE AL32UTF8;
–修改NLS_NCHAR_CHARACTERSET
SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;
SQL> shutdown immediate;
SQL> startup

–再次查询
SQL> select * from nls_database_parameters;