修改資料庫字符集

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 zhs16gbk;

檢查是否改變

SQL> shutdown immediate
SQL>startup mount
SQL>alter system disable restricted session;
SQL>alter system set job_queue_processes=10;

SQL> startup

SQL> select userenv('language') from dual;