Hi,
we did this conversion to AL32UTF8 with Oracles DMU Tool (Database Migration
Assistant for Unicode) in Sept 2017. Had to migrate several hundred
databases, after some testing it went really good.
Basically, the internal database structures are modified, and table data is
converted if required. After migrating, the database looks like a "real"
AL32UTF8 database. Meanwhile it can also work with GG, but we did not try
this.
First, the database is analysed, so that conversion of character-data can
take place. This step can be done online.
Second, the database is converted; the time needed depends on the amount of
data which must be converted. Conversion is done can be done by partitions
and tables, so parallel processing can be used.
One of the starting points is
https://www.oracle.com/technetwork/database/database-technologies/globalizat
ion/dmu/overview/index.html
Regards
willyk
Von: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im
Auftrag von Upendra nerilla
Gesendet: Mittwoch, 16. Januar 2019 21:12
An: Oracle-L <oracle-l@xxxxxxxxxxxxx>
Betreff: Characterset change
Hello Oracle Experts -
Environment: Redhat 6.7, EE 12.1
DB size: 4TB
We have been looking into switching the Characterset of a DB from
"WE8ISO8859P15" to "AL16UTF8".
This is a standalone Enterprise Edition database (non-RAC, No Data Guard).
We have looked at DB Migration Assistant and DataPump as possible options.
Both involves quite a bit of downtime,
wondering if there is a better way to perform this activity? Would
Transportable tablespace be an option?
Thanks much in advance
-Upendra
