RE: Conversion of Character Set from US7ASCII to UTF8 in RAC 10gR2

Just in case:  AL32UTF8 is not the same as UTF8.  It is a superset, but
there are cases where something is only verified and supported in a
particular character set, so be sure you are converting to the right
one.

 

I do not believe you have to export/import to go from US7ASCII to
UTF8/AL32UTF8.  You may wish to google or metalink for a faster
approach.

 

Joel Patterson 
Database Administrator 
joel.patterson@xxxxxxxxxxx 
x72546 
904  727-2546 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
Sent: Tuesday, December 19, 2006 10:14 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Conversion of Character Set from US7ASCII to UTF8 in RAC
10gR2

 

Missed the Step (3) in the previous e-mail. Added below now.

 

Additionally Should the Database NOT be Shutdown after the Truncate till
Step 5 is Complete?

 

________________________________

From: VIVEK_SHARMA 
Sent: Tuesday, December 19, 2006 8:33 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Conversion of Character Set from US7ASCII to UTF8 in RAC 10gR2

 

Folks

 

Need to Convert the Character Set of an Oracle10gR2 with RAC TEST
Database from the Default "US7ASCII" to UTF8

 

Is the following Procedure to be followed?

 

1) Shutdown the 2nd instance

 

2) Export ALL the Tables (including SYS, SYSTEM Schema) having CLOB
Datatype field 

select distinct ('TABLE '||A.OWNER|| '.'||A.TABLE_NAME) from
dba_tab_columns A, dba_tables B where A.table_name = B.table_name and
DATA_TYPE= 'CLOB'

 

3) Truncate ALL Tables having CLOB fields including those of SYS &
SYSTEM Schema

e.g. SYS.SQL$TEXT, SYS.RULE$

 

4) SQL> ALTER DATABASE CHARACTER SET AL32UTF8;

 

5) Import back ALL the Tables exported in Step 1

 

6) Export related Environment Variables:-

 

NLS_LANG=.AL32UTF8; export NLS_LANG

LANG=en_US.UTF-8; export LANG

LC_ALL=en_US.UTF-8; export LC_ALL

 

Thanks indeed

 

Vivek

 

 

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Other related posts: