oracle編碼轉換：AL32UTF8->ZHS16GBK

標籤：rac   資料庫   sys   base   character   lte   ora   修改   restrict   

 

--修改Oracle資料庫字元集為utf-8:    SQL>conn / as sysdba;    SQL>shutdown immediate;    SQL>startup mount;    SQL>alter system enable restricted session;    SQL>alter system set job_queue_processes=0;    SQL>alter system set aq_tm_processes=0;    SQL>alter database open;    SQL>alter database character set internal_use utf8; --zhs16gbk         SQL>shutdown immediate;    SQL>startup;  

　　

直接複製

--修改Oracle資料庫字元集為utf-8:    conn / as sysdba;    shutdown immediate;    startup mount;    alter system enable restricted session;    alter system set job_queue_processes=0;    alter system set aq_tm_processes=0;    alter database open;    alter database character set internal_use utf8; --zhs16gbk         shutdown immediate;    startup;  

　　

oracle編碼轉換：AL32UTF8->ZHS16GBK