关于oracle:Oracle-11g-空库修改字符集AL32UTF8-ZHS16GBK

31次阅读

共计 556 个字符,预计需要花费 2 分钟才能阅读完成。

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;

正文完
 0