Modifying the Oracle Database character set command under Linux

Common scenario: When backing up an Oracle database from a server to a local machine to restore an Oracle database, you often encounter inconsistent database character encoding, you can use the following command to modify the local Oracle Database character encoding, and then successfully restore the Oracle database to the local machine

Operation Instruction:

[Email protected] ~]$ Sqlplus/nolog

Sql> Conn/as sysdba;

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

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 internal_use us7ascii;

Sql>shutdown IMMEDIATE;

sql>startup;

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

Common Oracle Character sets are ZHS16GBK, Al32utf8, Us7ascii, and so on?