Flashback DB and DMU to Convert Characterset to Unicode (AL32UTF8) and Revert Back

(Doc ID 1947587.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jul-2017***

Goal

How to use Flashback database and DMU for preserve characterset and convert characterset to Unicode (AL32UTF8) and revert back to previous character set?

Can we use Flashback database and DMU to quickly come back to the state to before conversion?

Please Note

We have tested only with the conversion using DMU (not the csscan and csalter), also we recommend you to test in your lower environment before doing any migration or flashback

Lab Environment used for testing

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms