Oracle -- Set NS_NCHAR_CHARACTEREST
来源:互联网 发布:蜂窝移动网络数据漫游 编辑:程序博客网 时间:2024/06/17 22:11
--------------------1 change NLS_NCHAR_CHARACTERSET
SHUTDOWN IMMEDIATE;
STARTUP MOUNT exclusive RESTRICT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN ;
-------------------
update props$
set value$='AL16UTF16'
where name in ( 'NLS_NCHAR_CHARACTERSET');
commit;
SHUTDOWN IMMEDIATE;
STARTUP;
--select * from nls_database_parameters where parameter IN ('NLS_NCHAR_CHARACTERSET','NLS_CHARACTERSET);
--2 change NLS_CHARACTERSET to from WE8MSWIN1252 to AL32UTF8.
SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
alter database CHARACTER SET AL32UTF8;
SHUTDOWN IMMEDIATE;
STARTUP;
--3 if 2 is not work let's try this------------------------------------------------------------------
Execute the following commands in sqlplus connected as "/ AS SYSDBA":
1. SHUTDOWN IMMEDIATE;
2. STARTUP MOUNT;
3. ALTER SYSTEM ENABLE RESTRICTED SESSION;
4. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
5. ALTER SYSTEM SET AQ_TM_PROCESSES=0;
6. ALTER DATABASE OPEN;
7. ALTER DATABASE CHARACTER SET WE8MSWIN1252;
8. SHUTDOWN IMMEDIATE;
9. STARTUP RESTRICT;
10. SHUTDOWN;
11. STARTUP;
Now of course your database is then WE8MSWIN1252, so
you need to replace <existing database character set> with WE8MSWIN1252 from now on....
• Perform a backup of the database.
• Check the backup.
• Double-check the backup.
Then use the "alter database" command, this changes the current database
character set definition WITHOUT changing the actual stored data.
Shutdown the listener and any application that connects locally to the database.
There should be only ONE connection the database during the WHOLE time and that's
the sqlplus session where you do the change.
Now From WE8MSWIN1252 TO AL32UTF8
Execute the following commands in sqlplus connected as "/ AS SYSDBA":
1. SHUTDOWN IMMEDIATE;
2. STARTUP MOUNT;
3. ALTER SYSTEM ENABLE RESTRICTED SESSION;
4. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
5. ALTER SYSTEM SET AQ_TM_PROCESSES=0;
6. ALTER DATABASE OPEN;
7. ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
8. SHUTDOWN IMMEDIATE;
9. STARTUP;
now we have done....Database into AL32UTF8
- Oracle -- Set NS_NCHAR_CHARACTEREST
- oracle-set define/set feedback
- set oracle connectiong
- oracle character set
- Oracle Character set字符集
- Oracle set 命令
- ORACLE SET设置
- oracle set autotrace
- oracle supported character set
- Oracle sqlplus set
- oracle set 使用详解
- oracle set 变量
- oracle set serveroutput on
- oracle Set 命令介绍
- ORACLE的SET命令
- ORACLE set autotrace
- oracle Set 命令介绍
- oracle set 变量
- 视频会议系统——多分屏
- safari 中jQuery 第一次show没有显示
- CTEX初学一
- Android入门笔记之安卓布局常用属性
- 斗地主游戏制作流程(1)
- Oracle -- Set NS_NCHAR_CHARACTEREST
- Poj 3069 Saruman's Army【贪心】
- navigationBar 滑动 隐藏与显示 功能
- BZOJ3440 传球游戏
- Spring中applicationContext.xml位置问题
- 给定一个字符串,求出最长的连续配对括号子串的长度
- java wait和notify 简单理解
- [Leetcode] Lowest Common Ancestor of a Binary Tree
- Jenkins 常用配置设定 -- MacOS