这里是详细的步骤,不懂得可以留言!
第一步:查询V$NLS_PARAMETERS得到服务端的字符集:
SQL>SELECT * FROM V$NLS_PARAMETERS;
conn sys/(自己的oracle密码) as sysdba;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLERESTRICTED SESSION;
ALTER SYSTEM SETJOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SETAQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASECHARACTER SET internal_use ZHS16GBK;
SHUTDOWN IMMEDIATE;
STARTUP;