Globalization

How to Change Database Character Set

Posted on
Assuming that you have exported all the data to dump file for further process. Please shutdown the database.SQL> column parameter format a25;SQL> column value format a25;SQL> select parameter, value from v$nls_parameters where parameter like ‘%CHARACTERSET%’;PARAMETER                 VALUE————————- ————————-NLS_CHARACTERSET          ZHT16MSWIN950NLS_NCHAR_CHARACTERSET    AL16UTF16SQL> shutdown immediate;Database closed.Database […]