We want to recreate our database to UTF8 characterset. I am planning on taking an export tomorow with WE8ISO8859P1 then recreating the database with UTF8 characterset. Will I run into any problems with the Import because of the characterset changes?
"High Salaries = Happiness = Project Success."
I strongly suggest you to call ORACLE SUPPORT before you do character conversion.
And you may need to identify the data related recoveries...
U shouldn't any prombem with UNICODE, because:
FROM ORACLE DOC:
The Export utility always exports user data, including Unicode data, in the character sets of the Export server. The character sets are specified at database creation.
The Import utility automatically converts the data to the character sets of the Import server.
Some 8-bit characters can be lost (that is, converted to 7-bit equivalents) when you import an 8-bit character set export file. This occurs if the client system has a native 7-bit character set or if the NLS_LANG operating system environment variable is set to a 7-bit character set. Most often, you notice that accented characters lose their accent mark.
Both Export and Import provide descriptions of any required character set conversion before exporting or importing the data.
Pl find the following--
1. Set the environment variable
NLS_LANG to "_.WE8ISO8859P1"
2. Do a full export of the database
3. Create a new database with the database character set UTF8
4. Set the environment variable NLS_LANG to "_<
5. Import the export dump into the new database
Click Here to Expand Forum to Full Width