Database Administration (MOSC)

MOSC Banner

Character set migration from UTF8 to AL32UTF8

in Database Administration (MOSC)

Hello experts,

This is a topic which I found very less number of contents in web. Recently I was working for one of the utility application(Customer care &Billing) upgrade where oracle documentation clearly says to migrate character set to AL32UTF8 for multilingual support.

I have done some testing and wanted to share my experience.

Version:Oracle 19c

Platform:Oracle database appliance (19.15)

DB size:~ 4TB

Observation:-

Database scan: Took around 2 hrs

Scan report found 4 application tables and 1 sys objects starting with WHI$ which are non-convertible

for SYS schema it was some AWR related to table for stats advisor task.I have purged all stats advisor task and reran only that table and it clears that issue

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center