My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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 23-Jun-2018***

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?

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

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.