oracle字符集修改(AL32UTF8->UTF8)
来源:互联网 发布:js添加class 编辑:程序博客网 时间:2024/06/09 17:22
author:skate
time:2012/04/10
AL32UTF8->UTF8
步骤
shutdown immediate;
startup mount;
alter session set sql_trace=true;
alter system enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;
alter database open;
alter database character set internal_use utf8;
alter session set sql_trace=false;
shutdown immediate;
startup;
[root@detaildb ~]# su - oracle
[oracle@detaildb ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 6 09:55:53 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
修改之前的字符集
SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
----------------- ----------------------------
NLS_CHARACTERSET AL32UTF8
SQL>
开始修改
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2226912 bytes
Variable Size 402654496 bytes
Database Buffers 1191182336 bytes
Redo Buffers 7348224 bytes
Database mounted.
SQL> alter session set sql_trace=true;
Session altered.
SQL> alter system enable restricted session;
System altered.
SQL> show parameter job_queue_process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 1000
SQL> alter system set job_queue_processes=0;
System altered.
SQL> show parameter aq_tm_processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
SQL> alter database open;
Database altered.
SQL> alter database character set internal_use utf8;
Database altered.
SQL> alter session set sql_trace=flase;
alter session set sql_trace=flase
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> alter session set sql_trace=false;
Session altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2226912 bytes
Variable Size 402654496 bytes
Database Buffers 1191182336 bytes
Redo Buffers 7348224 bytes
Database mounted.
Database opened.
SQL>
修改之后的字符集
SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
----------------- ----------------------------
NLS_CHARACTERSET UTF8
SQL>
--------end-------
- oracle字符集修改(AL32UTF8->UTF8)
- oracle字符集修改(AL32UTF8->UTF8)
- Oracle 修改字符集(AL32UTF8 转换成UTF8字符集)
- oracle 字符集 AL32UTF8、UTF8
- oracle 字符集 AL32UTF8、UTF8
- oracle 字符集 AL32UTF8、UTF8
- oracle 字符集 AL32UTF8、UTF8
- AL32UTF8 和UTF8区别 --ORACLE 字符集
- AL32UTF8和UTF8字符集
- AL32UTF8和UTF8字符集
- AL32UTF8和UTF8字符集
- AL32UTF8和UTF8字符集
- RAC 修改字符集 AL32UTF8-->UTF8
- Oracle 如何AL32UTF8转换成SIMPLIFIED CHINESE_CHINA.UTF8字符集(转)
- 修改oracle字符集将字符编码WE8MSWIN1252修改为AL32UTF8
- 修改oracle字符集将字符编码WE8MSWIN1252修改为AL32UTF8
- 如何将Oracle原有字符集AL32UTF8修改为ZHS16GBK
- oracle 12c AL32UTF8字符集修改为ZHS16GBK
- Divitis: what it is, and how to cure it
- 关于SDL的gfx库
- Android handle机制
- 【博弈论】取棋子游戏
- Qt configure参数说明
- oracle字符集修改(AL32UTF8->UTF8)
- 二类动词记忆法
- 谨记:CoInitialize是以单线程的方式创建com对象
- centos 5.5 x64 + mysql5.5 + php5.2 yum安装过程
- Iphone之NSBundle
- java获取16进制的byte[]的String内容以及获取普通字符串的16进制的byte[]
- sales org.1->X-distr.chain status
- GridView导出数据到Excel(形如身份证等数据的处理)
- 肚子好饿