CentOS 6.3 (Linux) Oracle 10G 乱码

最新推荐文章于 2024-10-06 21:49:48 发布

weixin_30485379

最新推荐文章于 2024-10-06 21:49:48 发布

阅读量72

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/dule/archive/2012/12/04/2801140.html

版权

SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

SQL> shutdown immediate

SQL> startup mount

SQL> alter system enable restricted session;

SQL> show parameter job_queue_processes;

SQL> alter system set job_queue_processes=0;

SQL> alter database open;

SQL> alter database character set internal_use ZHS16GBK;          

SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

SQL> shutdown immediate

SQL> startup mount

SQL> alter system set job_queue_processes=10;

SQL> alter database open;