oracle数据库 gbk,oracle 数据库编码转换（转GBK） | 学步园

查看oracle数据库字符集：

select userenv('language') from dual;

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  135337420 bytes

Fixed Size                   452044 bytes

Variable Size             109051904 bytes

Database Buffers           25165824 bytes

Redo Buffers                 667648 bytes

Database mounted.

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL>alter database character set INTERNAL_USE UTF8

或者

SQL> alter database character set zhs16gbk

2  ;

alter database character set zhs16gbk

*

第 1 行出现错误:

ORA-12716: ??? CLOB ???, ?? ALTER DATABASE CHARACTER SET

alter database character set internal_convert zhs16gbk;