打开APP
未登录
开通VIP,畅享免费电子书等14项超值服
开通VIP
首页
好书
留言交流
下载APP
联系客服
oracle数据库字符集修改
lanyue211
>《oracle》
2012.07.14
关注
oracle字符集修改步骤
SQL> shutdown immediate;
Database
closed.
Database
dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System
Global
Area 1610612736 bytes
Fixed
Size
2066080 bytes
Variable
Size
385878368 bytes
Database
Buffers 1207959552 bytes
Redo Buffers 14708736 bytes
Database
mounted.
SQL>
alter
session
set
sql_trace=
true
;
Session altered.
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>
set
linesize 120;
SQL>
alter
database
character
set
zhs16gbk;
alter
database
character
set
zhs16gbk
*
ERROR
at
line 1:
ORA-12712: new
character
set
must be a superset
of
old
character
set
SQL>
ALTER
DATABASE
character
set
INTERNAL_USE zhs16gbk;
Database
altered.
SQL> shutdown immediate;
Database
closed.
Database
dismounted.
ORACLE instance shut down.
SQL> shutdown immediate;
ORA-01012:
not
logged
on
SQL> STARTUP
ORACLE instance started.
Total System
Global
Area 1610612736 bytes
Fixed
Size
2066080 bytes
Variable
Size
385878368 bytes
Database
Buffers 1207959552 bytes
Redo Buffers 14708736 bytes
Database
mounted.
Database
opened.
SQL>
select
name
,value$
from
props$
where
name
like
'%NLS%'
;
NAME
------------------------------
VALUE$
-------------------------------------------------------------------------------
----------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
NAME
------------------------------
VALUE$
-------------------------------------------------------------------------------
----------------------------------------
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS
.,
NLS_CHARACTERSET
ZHS16GBK
NAME
------------------------------
VALUE$
-------------------------------------------------------------------------------
----------------------------------------
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT
DD-MON-RR
NLS_DATE_LANGUAGE
AMERICAN
NAME
------------------------------
VALUE$
-------------------------------------------------------------------------------
----------------------------------------
NLS_SORT
BINARY
NLS_TIME_FORMAT
HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
NAME
------------------------------
VALUE$
-------------------------------------------------------------------------------
----------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY
$
NAME
------------------------------
VALUE$
-------------------------------------------------------------------------------
----------------------------------------
NLS_COMP
BINARY
NLS_LENGTH_SEMANTICS
BYTE
NLS_NCHAR_CONV_EXCP
FALSE
NAME
------------------------------
VALUE$
-------------------------------------------------------------------------------
----------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16
NLS_RDBMS_VERSION
10.2.0.4.0
20
rows
selected.
SQL>
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报
。
打开APP,阅读全文并永久保存
查看更多类似文章
猜你喜欢
类似文章
【热】
打开小程序,算一算2024你的财运
Linux下Oracle 10g乱码解决方案
ORACLE字符集问题总结
navicat连接oracle的错误:ora-12737:instant client l...
oracle服务端的字符集与客户端的字符集不一致
字符集查询与修改
oracle数据库字符集编码问题
更多类似文章 >>
生活服务
热点新闻
留言交流
回顶部
联系我们
分享
收藏
点击这里,查看已保存的文章
导长图
关注
一键复制
下载文章
绑定账号成功
后续可登录账号畅享VIP特权!
如果VIP功能使用有故障,
可点击这里联系客服!
联系客服
微信登录中...
请勿关闭此页面
先别划走!
送你5元优惠券,购买VIP限时立减!
5
元
优惠券
优惠券还有
10:00
过期
马上使用
×