Discussions
Categories
- 385K All Categories
- 2.5K Data
- 568 Big Data Appliance
- 2K Data Science
- 452K Databases
- 222.3K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 573 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.7K SQL & PL/SQL
- 21.5K SQL Developer
- 10 Data Integration
- 10 GoldenGate
- 297.6K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.2K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.3K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.1K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 172 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 573 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 182 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 239 Portuguese
What is the best way to change NLS_CHARACTERSET?
We are using a Oracle 11.2.0.4 database.
We wanted to change NLS_CHARACTERSET from "WE8MSWIN1252" to "AL32UTF8".
Can anybody suggest us a efficient plan?
Please share blogs or steps if any.
Comments
-
Consider using the Oracle Database Migration Assistant for Unicode, aka DMU (link).
But start by reading the documentation (link) carefully before doing anything, so you may anticipate the possible difficulties.
And make sure that you have a fallback plan (e.g. full backup, guaranteed restore point, etc.) in case things go wrong during (or after) the migration and you have to roll it back. This is a migration.
Regards,
-
Besides, the 11.2.0.4 release is now out of support, which means Oracle will not provide with any fix for that release anymore (unless you have paid for the Market-Driven Support extension, which entitles you to receive corrections of Severity-1 and security issues until 31 Dec. 2022).
This means that you'll probably have to upgrade to 19c very soon now, and therefore, you may want to delay the conversion to Unicode until after you've done that upgrade.
Regards,