查看Oracle数据库字符集
步骤 | 编码 |
---|---|
1、以sysdba身份登录 | conn sys/password(密码) as sysdba |
2、关闭数据库 | shutdown immediate; |
3、以mount打开数据库 | startup mount; |
4、查看编码格式 | select userenv(‘language’) from dual; |
4、设置session | alter system enable restricted session; |
alter system set job_queue_processes=0; | |
alter system set aq_tm_processes=0; | |
5、启动数据库 | alter database open; |
6、修改字符集 | alter database character set internal_use UTF8; |
7、关闭,重新启动 | shutdown immediate; |
startup; |