How to Change Database Character Set

Oracle Database

–To change the database character set of Oracle database login as sys with sysdba privileges using sqlplus

whenever sqlerror continue;
spool Validate_db.log
set serveroutput on size 100000;
SHUTDOWN IMMEDIATE; -- or NORMAL
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
SHUTDOWN IMMEDIATE; -- or NORMAL
STARTUP;
--to check the changed char set value.
SELECT * FROM sys.props$ WHERE name = 'NLS_CHARACTERSET';

It’s sometimes potentially dangerous to change the NLS_CHARACTERSET or database character set of existing database as it might corrupt your data and can make your DB unusable. Please refer more on changing the database character set from the oracle article.

In case of any ┬ęCopyright or missing credits issue please check CopyRights page for faster resolutions.

Leave a Reply