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

(Doc ID 1947587.1)

Last updated on JUNE 12, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1]
Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 23-Jun-2018***


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?

How do we reverse back the characterset conversion with flashback ?

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


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