Tag Archives: charset

修改数据库字符集为：ZHS16GBK 查看服务器端字符集 SQL > select * from V$NLS_PARAMETERS 修改： $sqlplus /nolog SQL>conn / as sysdba; 若此时数据库服务器已启动，则先执行 SHUTDOWN IMMEDIATE 命 令关闭数据库服务器，然后执行以下命令: 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; … Continue reading →