Oracle Database Encoding Conversion

Scenario: There is a database encoded as UTF8 on the server, and then the local is ZHS16GBK. I directly with the EXP command to guide down, found that the database is garbled.

Resolution process: Because the code on the server is not easy to change, so consider the local encoding to UTF8, import, and then convert the local encoding to ZHS16GBK.

1, first check the local database code, the statement is

2, and then start to modify the local database code: Open cmd, enter Sqlplus, and then enter the username password login.

3, the use of the following code, to change the database code (direct copy paste into the cmd can be directly run), here is the local database to change the International Code UTF8, the state code for the time being not tube.

Conn/as sysdba;
 Shutdown immediate;
 startup Mount;
 ALTER SYSTEM ENABLE restricted session;
 ALTER SYSTEM SET job_queue_processes=0;
 ALTER SYSTEM SET aq_tm_processes=0;
 ALTER DATABASE open;
 ALTER DATABASE character set Internal_use UTF8; 
 Shutdown immediate;
 Startup

4. Export the UTF8 library on the server using EXP and import it into local with Imp.