| conversion of NLS_CHARACTERSET FROM AL32UTF8 TO UTF8 [message #272922] |
Mon, 08 October 2007 03:30  |
kamragulshan
Messages: 66
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 #272965 is a reply to message #272953] |
Mon, 08 October 2007 06:44  |
 |
Michel Cadot
Messages: 68686
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
