修改server端字符集

    技术2022-05-19  19

    上次刚装完Oracle,但是字符集忘记改了,在网上找了资料,成功。

    $sqlplus /nolog   SQL>conn / as sysdba;   若此时数据库服务器已启动,则先执行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 ZHS16GBK;   SQL>ALTER DATABASE national CHARACTER SET ZHS16GBK;   SQL>SHUTDOWN IMMEDIATE;   SQL>STARTUP SQL>select * from nls_database_parameters


    最新回复(0)