Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Character set migration NLS_CHARACTERSET : AR8MSWIN1256 TO AL32UTF8

MannaiMar 25 2020 — edited Mar 25 2020

DB: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

OS: Red Hat Enterprise Linux Server release 7.6 (Maipo)

I'm following the Doc: The Database Migration Assistant for Unicode (DMU) Tool ( Doc ID 1272374.1 )

Plan to convert:

NLS_CHARACTERSET from AR8MSWIN1256 to AL32UTF8

NLS_NCHAR_CHARACTERSET is UTF8 (no change)

I have cleansed all the user application data.. (Modified the datatype semantics lenght as per the recommendation by DMU)

I am not sure how to proceed with the metadata cleansing?

Message from DMU: The table contains user data that cannot be successfully converted to Unicode.

Table Column Name: SYS**.WRI$_ADV_OBJECTS.**ATTR5

pastedImage_9.png

pastedImage_22.png

pastedImage_23.png

Any kind of help is appreciated.

This post has been answered by GregV on Mar 25 2020
Jump to Answer
Comments
Post Details
Added on Mar 25 2020
7 comments
736 views