re: ORACLE常用技巧 弦驚塞外 2019-05-15 18:48
5.1 修改server端字符集(不建議使用)
1. 關(guān)閉數(shù)據(jù)庫
SQL>SHUTDOWN IMMEDIATE
2. 啟動(dòng)到Mount
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 ZHS16GBK;
SQL>ALTER DATABASE NATIONAL CHARACTER SET ZHS16GBK;
--如果是從子集到父集,需要使用INTERNAL_USE 參數(shù),跳過超子集檢測
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
SQL>ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL32UTF8;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP
@高
build-ext是包含在build.xml里面的一個(gè)子構(gòu)建項(xiàng),在build.xml的第673行處