AW: Characterset change

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von Upendra nerilla
Gesendet: Mittwoch, 16. Januar 2019 21:12 An: Oracle-L <oracle-l_at_freelists.org> 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

--
http://www.freelists.org/webpage/oracle-l