Oracle数据库字符集的问题
(2011-07-29 10:44:59)
标签:
oracle
charset
it
查看可用的语言和字符集
select * from v$nls_valid_values;
查看当前的配置
select * from v$nls_parameters;
NLS_CHARACTERSET是数据库支持的字符集,如果要修改可采用如下步骤(见
http://forums.oracle.com/forums/thread.jspa?threadID=359124),
Shut down the database, using either a SHUTDOWN IMMEDIATE or a
SHUTDOWN NORMAL statement. Do a full backup of the database because
the ALTER DATABASE CHARACTER SET statement cannot be rolled
back.
Complete the following statements:
4. STARTUP MOUNT;
5. ALTER SYSTEM ENABLE RESTRICTED SESSION;
6. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
7. ALTER SYSTEM SET AQ_TM_PROCESSES=0;
8. ALTER DATABASE OPEN;
9. ALTER DATABASE CHARACTER SET new_character_set;
10. SHUTDOWN IMMEDIATE; -- or SHUTDOWN NORMAL;
11. STARTUP;
如果字符集不兼容则会修改失败,报错
ORA-12712: new character set must be a superset of old character
set
此时创建新的数据库也许是最好的做法。
参考
http://www.cnblogs.com/pan11jing/archive/2009/12/04/1617097.html
分享:
喜欢
0
赠金笔
加载中,请稍候......
评论加载中,请稍候...
发评论
登录名: 密码: 找回密码 注册记住登录状态
昵 称:
评论并转载此博文
发评论
以上网友发言只代表其个人观点,不代表新浪网的观点或立场。