- select userenv('language') from dual; //查看系统字符集编码
- select * from nls_database_parameters where parameter in ('NLS_CHARCTERSET','NLS_NCHAR_CHARACTERSET');
- shutdown immediate
- startup
- alter session set sql_trace=true;
- alter system enable restricted session;
- show parameter job_queue_processes;
- alter system set job_queue_processes=0;
- alter system set aq_tm_processes=0;
- alter database character set INTERNAL_USE AL32UTF8;
- update props$ set VALUE$='UTF8' where NAME='NLS_NCHAR_CHARACTERSET';
posted @
2017-09-13 15:44
dreamzhao
阅读(
997)
评论()
编辑
收藏
举报