Shulou(Shulou.com)06/01 Report--

This article is about how to convert the oracle character set. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

I wanted to transfer the oracle tablespace under windows to RAC linux

But the windows oracle character set is ZHS16GBK and the linux oracle character letter is AL32UTF8

Convert the character set under windows to AL32UTF8 at that time

SQL > select userenv ('language') from dual

USERENV ('LANGUAGE')

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

The following is the process of modification

SQL > startup mount

The ORACLE routine has been started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 176161684 bytes

Database Buffers 352321536 bytes

Redo Buffers 5844992 bytes

The database is loaded.

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 AL32UTF8

The database has changed.

SQL > shutdown immediate

The database has been closed.

The database has been uninstalled.

The ORACLE routine has been closed.

SQL > startup

The ORACLE routine has been started.

-- View character set

SQL > select userenv ('language') from dual

USERENV ('LANGUAGE')

SIMPLIFIED CHINESE_CHINA.AL32UTF8

After modification, more than 10g use csscan tool to verify the character set

Install first

@ $ORACLE_HOME/RDBMS/admin/csminst.sql

Under DOS

Csscan system/1

Character Set Scanner v2.2: Release 11.1.0.6.0-Production on Wednesday December 21 14:12:50 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

1) Full database, 2) User, 3) Table, 4) Column: 1 > 1

Current database character set is AL32UTF8.

Enter new database character set name: > AL32UTF8

Enter array fetch buffer size: 1024000 >

Enter number of scan processes to utilize (1.. 32): 1 >

Yes, post-verification was successful!

The above is how to convert the oracle character set. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.