Home » RDBMS Server » Server Administration » conversion of NLS_CHARACTERSET FROM AL32UTF8 TO UTF8
conversion of NLS_CHARACTERSET FROM AL32UTF8 TO UTF8 [message #272922] Mon, 08 October 2007 03:30 Go to next message
kamragulshan
Messages: 63
Registered: May 2005
Location: Delhi
Member
I have oracle database on 10.1.0.2 on linux and the NLS_CHARACTERSET is AL32UTF8
and NLS_NCHAR_CHARACTERSET is UTF8.
Now i need to change the nls_characterset from AL32UTF8 to UTF8.
Please provide me the steps for characterset conversion.

Also i have few doubts:

1. Is there any data loss during this conversion.
2. Can we change the characterset for only one schema.
3. How to crosscheck after conversion, if conversion successfully complete.

Thanks in Advance.
Gulshan
Re: conversion of NLS_CHARACTERSET FROM AL32UTF8 TO UTF8 [message #272923 is a reply to message #272922] Mon, 08 October 2007 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Is there any data loss during this conversion.
It may be

2. Can we change the characterset for only one schema.
No

3. How to crosscheck after conversion, if conversion successfully complete.
Do it before using csscan.

In addition and most important: DON'T USE UTF8, it is an obsolete character set.

Regards
Michel
Re: conversion of NLS_CHARACTERSET FROM AL32UTF8 TO UTF8 [message #272953 is a reply to message #272922] Mon, 08 October 2007 06:06 Go to previous messageGo to next message
kamragulshan
Messages: 63
Registered: May 2005
Location: Delhi
Member
Thanks for your reply and kind suggestion.

This is the specific requirement of our client to convert the nls_characterset from AL32UTF8 to UTF8.


What precautions should i take before starting conversion process?

Could you please provide me the steps for conversion?

Thanks
Gulshan
Re: conversion of NLS_CHARACTERSET FROM AL32UTF8 TO UTF8 [message #272965 is a reply to message #272953] Mon, 08 October 2007 06:44 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

What precautions should i take before starting conversion process?

Use csscan

Quote:

Could you please provide me the steps for conversion?

They are describe in documentation.

You should ask your client what is the reason to go to hell. There WILL have problems in the future. Maybe it is a good thing for you as you have to make another migration in a while.

Regards
Michel
Previous Topic: Oracle analyze
Next Topic: Blob inquiries on sizes
Goto Forum:
  


Current Time: Wed Dec 07 20:49:35 CST 2016

Total time taken to generate the page: 0.11189 seconds