Oracle 11g 空库修改字符集:AL32UTF8 --> ZHS16GBK

Oracle 11g 空库修改字符集:AL32UTF8 --> ZHS16GBK

-- 空库修改字符集:AL32UTF8 --> ZHS16GBK
SHOW PARAMETER JOB_QUEUE_PROCESSES;
SHOW PARAMETER AQ_TM_PROCESSES;
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 ZHS16GBK;
ALTER SYSTEM SET NLS_LANGUAGE='AMERICAN' SCOPE=SPFILE;
ALTER SYSTEM SET NLS_TERRITORY='AMERICA' SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;
SELECT USERENV('LANGUAGE') FROM DUAL;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=1000;
ALTER SYSTEM SET AQ_TM_PROCESSES=1;

你可能感兴趣的