修改Oracle数据库的字符集为UTF-8

在SQL*PLUS 中，以DBA登录

命令：

 1 >shutdown immediate; (把database停了)
 2 
 3 >startup mount; (把database重开)
 4 
 5 >alter system enable restricted session;
 6 
 7 >alter system set job_queue_processes=0;
 8 
 9 >alter system set aq_tm_processes=0;
10 
11 >alter database open;
12 
13 >alter database character set utf8;
14 
15 OR
16 
17 >alter database character set internal_use utf8;
18 
19 >shutdown immediate;
20 
21 >startup; (重开正常oracle)

 

转载于:https://www.cnblogs.com/yph5233/p/8994791.html