Re: Need to convert database characterset from WE8ISO8859P1 TO AL32UTF8
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: dubey.sandeep@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 26 Jan 2007 10:58:20 -0800
Check with these Metalink Notes
Note:260192.1 Changing WE8ISO8859P1/ WE8ISO8859P15 or WE8MSWIN1252 to
(AL32)UTF8 with ALTER DATABASE CHARACTERSET
Note:225912.1 Changing the Database Character Set - a short overview
Note:119119.1 AL32UTF8 / UTF8 (unicode) Database Character Set Implications
Note:227330.1 Character Sets & Conversion - Frequently Asked Questions
HTH
GovindanK
On Fri, 26 Jan 2007 12:52:32 -0500, [1]"Sandeep Dubey"
<dubey.sandeep@xxxxxxxxx> said:
> Hi all
>
> Platofrm: Oracle 10.2 on Linux 2.4
>
> I need to convert database characterset from WE8ISO8859P1 TO AL32UTF8.
> Following is a part of csscan output. Some application data is
> convertible. I have blob data in the application. It is nowhere
> reported whether it is covertinble or changless in the csscan output
> scan.txt file.
>
> Can I safely convert the database using csalter script? If yes, what
> will happen to application data in Convertible column?
>
> Or I must use export import? Problem is our production database export
> and import will take over 24 hours and we can not take that much down
> time.
>
......
> Thanks
>
> Sandeep
> --
> [2]www.freelists.org/webpage/oracle-l
>
>
References
1. mailto:dubey.sandeep@xxxxxxxxx
2. file://localhost/tmp/linkstmp/www.freelists.org/webpage/oracle
Other related posts:
