--install character set migration utility schema

SQL> @?/rdbms/admin/csminst.sql

--backup and restart database

SQL> alter system set cluster_database=false scope=spfile; --RAC only

SQL> shutdown immediate;

SQL> startup;

--perform. a scan of the whole database

csscan \”sys/xxxx@uiet10 as sysdba\” full=y

Current database character set is WE8MSWIN1252.

Enter new database character set name: > WE8ISO8859P15

Enter array fetch buffer size: 1024000 >

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

--shutdown database and startup database in restricted mode, and run the conversion process

SQL> shutdown immediate;

SQL> startup restrict;

SQL> @?/rdbms/admin/csalter.plb

--shutdown and restart the database as normal

SQL> alter system set cluster_database=true scope=spfile; --RAC only

SQL> shutdown immediate;

SQL> startup;

--check csalter.err log file for any error

ITPub博客

How to do oracle database character set migration