首页 > 数据库技术 > 详细

如何查看及修改oracle编码格式方法

时间:2014-11-16 15:53:41      阅读:284      评论:0      收藏:0      [点我收藏+]

  select userenv(‘language‘) from dual;

 

  SIMPLIFIED CHINESE_CHINA.AL32UTF8

  sql> conn / as sysdba;

  sql> shutdown immediate;

  database dismounted.

  sql> startup mount;

  total system global area  135337420 bytes

  fixed size                          452044 bytes

  variable size                     109051904 bytes

  database buffers              25165824 bytes

  redo buffers                      667648 bytes

  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 UTF8

  sql> shutdown immediate;

  sql> startup;

如何查看及修改oracle编码格式方法

原文:http://www.cnblogs.com/waying/p/4101476.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!