ORACLE 12C: Data Migration Assistant
The Database Migration Assistant for Unicode (DMU) provides a good solution for migrating databases from legacy character sets to the Unicode character set.
It is shipping with Oracle Database 12c Rel.1 and becomes the officially supported method for migration to the Unicode character set. Database Character Set Scanner (CSSCAN) and CSALTER utilities are removed from the database installation and have been desupported.
DMU also supports migrating selected prior database releases of 10.2, 11.1 and 11.2.
Oracle DMU 2.1, released in May 2015, supports a near-zero downtime migration model in conjunction with the Oracle GoldenGate replication technology. Using DMU2.1 and GoldenGate 12.1.2.1.0 or later.
You can set up a migration procedure that takes advantage of the DMU data preparation and leveraging GoldenGate to replicate incremental data changes on the production system during the migration process.
Oracle Database Migration Assistant for Unicode provides a seamless workflow that drastically reduces administrative cost and complexity by covering:
– Enumeration – auto identification of database objects containing textual data that requires conversion.
– Scanning – comprehensive assessment of migration feasibility and discovery of potential data issues.
– Cleansing – sophisticated toolset for iterative data analys is and cleansing to ensure data safety.
– Conversion – automated in – place data conversion to minimize time and space Requirements.