oracle 修改字符集
来源:互联网 发布:同步带轮生成软件 编辑:程序博客网 时间:2024/06/06 00:42
-查看oracle数据库字符集:
select userenv('language') from dual;
查询结果:
SIMPLIFIED CHINESE_CHINA.AL32UTF8
ALTER SYSTEM DISABLE RESTRICTED SESSION;改完编码后执行
sql> conn / as sysdba;
sql> shutdown immediate;
database closed.
database dismounted.
oracle instance shut down.
sql> startup mount;
oracle instance started.
total system global area 135337420 bytes
fixed size 452044 bytes
variable size 109051904 bytes
database buffers 25165824 bytes
redo buffers 667648 bytes
database mounted.
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> alter database character set internal_use JA16SJIS;。
select userenv('language') from dual;
查询结果:
SIMPLIFIED CHINESE_CHINA.AL32UTF8
--修改oracle数据库字符集:(在SQL Plus中)
sqlplus sys/oracle as sysdba
conn sys/oracle as sysdbaALTER SYSTEM DISABLE RESTRICTED SESSION;改完编码后执行
sql> conn / as sysdba;
sql> shutdown immediate;
database closed.
database dismounted.
oracle instance shut down.
sql> startup mount;
oracle instance started.
total system global area 135337420 bytes
fixed size 452044 bytes
variable size 109051904 bytes
database buffers 25165824 bytes
redo buffers 667648 bytes
database mounted.
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> alter database character set internal_use JA16SJIS;。
0 0
- ORACLE 字符集乱码 修改字符集
- Oracle字符集修改问题
- oracle 修改字符集
- Oracle修改字符集
- 修改oracle的字符集
- 修改oracle默认字符集
- oracle 修改字符集
- 修改oracle数据库字符集
- 修改oracle字符集
- Oracle字符集修改
- 修改ORACLE字符集
- 修改oracle字符集
- 修改oracle字符集
- 修改Oracle数据库字符集
- Oracle修改字符集全过程
- oracle 修改字符集
- oracle修改字符集
- oracle修改“NLS_NCHAR_CHARACTERSET”字符集
- Java BeanValidation
- map的四种遍历方法
- [Q学习]13 Qt状态机框架——简单的状态机
- Android 如何让程序定时进行消息通知到通知栏
- CentOS_6.6上, FastDFS分布式文件系统搭建和Java测试
- oracle 修改字符集
- Android Studio 快捷操作将字符串快速整理到string.xml
- 5、RedHat6 集群多路径
- Tomcat布署问题备忘
- 详解如何用 SPSS + BigInsights 共同构架大数据分析平台
- Android Studio集成SVN报错:can't use subversion command line client : svn
- C 基础
- iOS7+ 获取网络类型
- Ubuntu 16.04 搭建LAMP开发环境