Oracle 12c Character Set modification Al32utf8 to Zhs16gbk____oracle

The company installs an Oracle 12c test environment, is ready to export the online library to test performance, the results of the test library of the character set selected Al32utf8, a look at the line is ZHS16GBK, or to maintain the same, and then record Al32utf8 ZHS16GBK character Set process:

first, the most important thing: backup. Back up your data. Don't forget to back up your data.

C:\windows\system32>sqlplus/nolog sql*plus:release 12.1.0.2.0 Production on Tuesday February 10:59:23 2018 Copyright (c) 1  MB, 2014, Oracle.

All rights reserved.
Sql> Conn/as Sysdba is connected.

Sql> Select Userenv (' language ') from dual; USERENV (' LANGUAGE ')--------------------------------------------------------------------------------simplified Chinese_china.
The Al32utf8 sql> shutdown immediate database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.
sql> STARTUP MOUNT EXCLUSIVE;

The ORACLE routine has started. Total System Global area 2533359616 bytes Fixed size 3835256 bytes Variable Size 738200200 by
TEs databases buffers 1778384896 bytes Redo buffers 12939264 The database has completed loading.

sql> ALTER SYSTEM ENABLE restricted session;

The system has changed.

sql> ALTER SYSTEM SET job_queue_processes=0;

The system has changed.

sql> ALTER SYSTEM SET aq_tm_processes=0;

The system has changed.

sql> ALTER DATABASE OPEN;

The database has changed.

sql> ALTER DATABASE CHARACTER SET internal_use ZHS16GBK;

The database has changed. Sql> ALTER DATABASE National CHARACTER SET internal_use al16utf16;

The database has changed.
The sql> SHUTDOWN IMMEDIATE database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.

The sql> startup ORACLE routine has started. Total System Global area 2533359616 bytes Fixed size 3835256 bytes Variable Size 738200200 by
TEs databases buffers 1778384896 bytes Redo buffers 12939264 The database has completed loading.
The database is already open.

Sql> Select Userenv (' language ') from dual; USERENV (' LANGUAGE ')----------------------------------------------------simplified Chinese_china.
ZHS16GBK sql> col parameter format A32;
sql> col value format A32;

Sql> select * from Nls_database_parameters;                 PARAMETER VALUE----------------------------------------------------------------nls_rdbms_version                         12.1.0.2.0 nls_nchar_conv_excp FALSE nls_length_semantics BYTE Nls_comp BINARY nls_dual_currency $ nls_timestamp_tz_format dd-mon-rr hh.mi. SSxff AM tzr Nls_time_tz_format hh.mi. Ssxff AM tzr nls_timestamp_format dd-mon-rr hh.mi. Ssxff AM Nls_time_format HH.MI.                        Ssxff AM nls_sort BINARY nls_date_language American PARAMETER VALUE----------------------------------------------------------------Nls_date_format dd-mon-rr Nls_ CALENDAR Gregorian nls_numeric_characters., Nls_nchar_characterset al16utf16 Nls_ CHARACTERSET ZHS16GBK nls_iso_currency AMERICA nls_currency $ nls_terr

Itory AMERICA nls_language American has selected 20 rows. Sql>

Oracle 12c modifies the Al32utf8 character set to ZHS16GBK completion.