Flashback DB and DMU to Convert Characterset to Unicode (AL32UTF8) and Revert Back
Last updated on JUNE 12, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 12.1]
Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [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 ?
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