20110218周五

    技术2026-04-17  1

     修改数据库的字从字符集

     sqlplus: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 ZHS16GBK;--AL32UTF8

        SQL> SHUTDOWN IMMEDIATE;

        SQL> STARTUP;

    最新回复(0)