怎样把oracle数据库的字符集设置成utf8

怎样把oracle数据库的字符集设置成utf8

 

修改oracle字符集：
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter database open;
SQL> alter database character set internal_use UTF8;
SQL> shutdown immediate;
SQL> startup

 

用dba登录否则权限不够