Oracle Database Character set Change from AL32UTF8 to WE8MSWIN1252
Character set Change from AL32UTF8 to WE8MSWIN1252 I tested below procedure successfully in Test Environment . Case 1: Simple alter statement does not work in this case.. SYS@S2411S > ALTER DATABASE CHARACTER SET WE8MSWIN1252; ALTER DATABASE CHARACTER SET WE8MSWIN1252 * ERROR at line 1: ORA-12712: new character set must be a superset of old character set Case 2: Steps to Change CHARACTER SET ***************************** Step 1: Install CSSCAN cd $ORACLE_HOME/rdbms/admin sqlplus “/as sysdba” @csminst.sql Find log file for sample result for this execution. ********************* Step 2: Run csscan from command line. csscan sys/Welcome123 fromchar= al32utf8 tochar= we8mswin1252 full=y [oracle@s24-oratl15 admin]$ csscan \"sys as sysdba\" full=y fromchar=al32utf8 tochar=we8mswin1252 Character Set Scanner v2.2 : Release 11.2.0.4.0 - Production on Tue Apr 19 15:54:13 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. ...