如何查看及修改oracle编码格式方法_Oracle数据库_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

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

作者:黑客防线网安Oracle维护基地 来源:黑客防线网安Oracle维护基地 浏览次数:0

本篇关键词:Oracle数据库Oracle教程
黑客防线网安网讯:    --查看oracle数据库字符集:  select userenv('language') from dual;  查询结果:  SIMPLIFIED CHINESE_CHINA.AL32UTF8  --修改oracle数据库字符集:(在SQL Plus中)...
    --查看oracle数据库字符集:
  select userenv('language') from dual;
  查询结果:
  SIMPLIFIED CHINESE_CHINA.AL32UTF8
  --修改oracle数据库字符集:(在SQL Plus中)
  sql> conn / as sysdba;
  sql> shutdown immediate;
  database closed.
  database dismounted.
  oracle instance shut down.
  sql> startup mount;
  oracle instance started.
  total system global area  135337420 bytes
  fixed size                          452044 bytes
  variable size                     109051904 bytes
  database buffers              25165824 bytes
  redo buffers                      667648 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 JA16SJIS;
  sql> shutdown immediate;
  sql> startup;
    黑客防线网安服务器维护方案本篇连接:http://www.rongsen.com.cn/show-13069-1.html
网站维护教程更新时间:2012-03-23 00:50:05  【打印此页】  【关闭
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer