CHANGING THE CHARACTER SET TO AL32UTF8 on Oracle Database

Spread the love

 
 

# SQLPLUS /AS SYSDBA

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP RESTRICT

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

 
 

SQL> ALTER DATABASE CHARACTER SET AL32UTF8;

 
 

SQL> SHUTDOWN IMMEDIATE

 
 

SQL> STARTUP

 
 

SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ ;

 
 

 
 


Leave a Reply

Your email address will not be published. Required fields are marked *