问题:
在导入oracle数据库,但是发现导入后数据都是乱码。
解决办法:
以下语句是对该问题的一些整理,供参考;在终端中执行以下操作:
#su - oralce
SQL> sqlplus / 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 ZHS16GBK;
ORA-12712: new character set must be a superset of old character set (意思是新字符集必须为旧字符集的超集,跳过即可)
SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;
SQL> shutdown immediate;
SQL> startup
PS:
Oracle 11g更改字符集AL32UTF8为ZHS16GBK