可以采用如下的步骤修改数据库的字符集SQL> SHUTDOWN IMMEDIATE; -- or NORMAL
<do a full backup>
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET <new_character_set_name>;
SQL> SHUTDOWN IMMEDIATE; -- or NORMAL
SQL> STARTUP;
<do a full backup>
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET <new_character_set_name>;
SQL> SHUTDOWN IMMEDIATE; -- or NORMAL
SQL> STARTUP;
解决方案 »
- Oracle数据库与MS-SQL Server数据库两个表之间无法实现同步删除
- truncate table后,FSFI值反而降低
- sql查询转置
- function 调用 package
- 禁止更新本月以前数据,触发器怎么写?
- VB.net能连接ORACLE;ASP.net却不能连接ORACLE。这是怎么回事????
- 求获取当前记录的 前一条记录 和后一条句路的 查询语句 (不用变量)
- 大家看看存储过程代码有什么问题!!
- 问一个超级菜的问题,请大家帮帮忙啊。.sql的程序该怎样执行呀?
- Oracle 8.16与8I有什么区别
- oracle9i中的数据如何倒入到oracle8.0.4中
- 奇奇怪怪:用dbstart能正常启动用svrmgrl和sqlplus就不行,青睐看看阿
oracle national language support guide
now maybe it's just a matter to display them in your client . for that change the nls_lang in your registry . ( there are plenty of threads discussing about it )光说不练之龙飞虎
你将NLS_LANG修改为SIMPLIFIED CHINESE_CHINA.ZHS16GBK
而后重新插入数据,再显示看看
如果数据库的字符集有问题的话,STARTUP MOUNT不一定能启动数据库,