Common scenario: When backing up an Oracle database from the server and restoring the Oracle database on the local machine, you often encounter inconsistent database character encoding, and can use the following command to change the local Oracle database character encoding, 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?
Change Oracle Database Character set command under Linux