Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrating WE8MSWIN1252 to AL32UTF8

326156Apr 2 2008 — edited Jul 26 2011
Hello,

For what I read on the various (detailed) documents on metalink, migrating a database character set from WE8MSWIN1252 to a unicode set is possible by migrating the whole database.

But I've got this scenario: only 3 schemes from the WE8MSWIN1252 database need to be migrated to a new AL32UTF8 database. In this case, which is the best way to proceed?

If I install a new AL32UTF8 database, can I export the schemas from the WE8MSWIN1252 and import them in the AL32UTF8 one, provided that there are just convertible data (no lossy, no truncation)?

Or am I "forced" to change the whole WE8MSWIN1252 database to the new character set, then export the 3 schemas and import them in the new db?

Thanks for your help,

- Paolo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2011
Added on Apr 2 2008
#database-key-features, #globalization-support
21 comments
28,851 views