Oracle11.2.0.4字符集修改(GBK→UTF-8)实战

Microsoft Windows [版本 10.0.22000.675]
(c) Microsoft Corporation。保留所有权利。

C:\Users\admin>sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on 星期三 6月 15 09:08:07 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

C:\Users\administrator>sqlplus sys/sys as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on 星期三 6月 15 09:08:41 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
--------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。

Total System Global Area 5044088832 bytes
Fixed Size                  2289920 byt