Hello,

Oracle 10.2.0.3 on Linux 4 64-bit; DB size 170G

I am looking at ways to change a database's characterset from WE8ISO8859P1 to AL32UTF8.

I went through a few Metalink documents and ran the CSSCAN tool as well.
The tool reported several convertible, truncation and Lossy data.

My question is this: which is the best method for characterset migration?

1. Create new DB with AL32UTF8 characterset and import only the schema(s) affected? (after increasing truncation table columns and exporting the schema(s)

2. Create new DB with AL32UTF8 characterset and use transportable tablespace?

If anyone hs actually done the migration, I would appreciate them sharing their experience.

Thanks!
Suhas