首先檢視oracle資料庫的編碼:SQL> select * from nls_database_parameters where parameter ="NLS_CHARACTERSET";修改字符集編碼(這會對資料庫的資料有直接的影響,謹慎操作):SQL>conn /as sysdbaSQL>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;SQL>shutdown immediate;SQL> startup
首先檢視oracle資料庫的編碼:SQL> select * from nls_database_parameters where parameter ="NLS_CHARACTERSET";修改字符集編碼(這會對資料庫的資料有直接的影響,謹慎操作):SQL>conn /as sysdbaSQL>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;SQL>shutdown immediate;SQL> startup