Modify character set commands of Oracle databases in Linux

Common scenarios: When you back up the Oracle database from the server and restore the Oracle database to a local machine, you will often encounter inconsistency in the character encoding of the database.

Common scenarios: When you back up the Oracle database from the server and restore the Oracle database to a local machine, you will often encounter inconsistency in the character encoding of the database.

Homepage → Database Technology

Background:

Read News

Modify character set commands of Oracle databases in Linux

[Date: 2014-05-10] Source: Linux community Author: Linux [Font:]

Common scenarios: When the Oracle database is backed up from the server and then restored to the local machine, the character encoding of the database is inconsistent, you can run the following command to modify the character encoding of the local Oracle database, and then restore the Oracle database to the local machine.

Operation Command:

[Oracle @ gpdb ~] $ 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 include ZHS16GBK, AL32UTF8, and US7ASCII.

Modify Oracle character set in Linux: WE8ISO8859P1 to ZHS16GBK

0

Install Oracle 11g in Linux

Oracle random function DBMS_RANDOM

Related information: Oracle Database Character Set modification: Oracle Database Character Set

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2014 Linux community All rights reserved Zhejiang ICP backup No. 06018118

,