RE: Characterset change

Upendra,

On a side note. Since you are are on RHEL 6.7, which is due for EOL and so is 12.1 by year-end. You might want to club this migration within same downtime(unless, ofcourse you want to create a physical standby(mounted) which doesn't need extra license other than EE. Don't open it in read-only).

In my experience, you might want to work with application team around lossy data that has no means of conversion. Most of the times vendor applications built on such code pages don't readily change, and you end up continuing the same.

• DBMA ll let you validate changes, and you can put of it in an excel(report) and compute storage requirements. You may want to add some buffer as well.
• Datapump ll not handle lossy data.
• TTS can't be used for characterset change.

Thanks,
Yogi
Disclaimer: The information transmitted is intended for the person or entity to which it is addressed and may contain confidential, privileged or copyrighted material or attorney work product. If you receive this in error, please contact the sender and delete the material from any system. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Any comments or statements made are not necessarily those of Fidelity. All e-mails may be monitored or recorded.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Upendra nerilla Sent: 17 January 2019 01:42
To: Oracle-L <oracle-l_at_freelists.org> Subject: Characterset change

Hello Oracle Experts -

Environment: Redhat 6.7, EE 12.1
DB size: 4TB

We have been looking into switching the Characterset of a DB from "WE8ISO8859P15" to "AL16UTF8". This is a standalone Enterprise Edition database (non-RAC, No Data Guard).

We have looked at DB Migration Assistant and DataPump as possible options. Both involves quite a bit of downtime, wondering if there is a better way to perform this activity? Would Transportable tablespace be an option?

Thanks much in advance
-Upendra

--
http://www.freelists.org/webpage/oracle-l