Oracle Basic Tutorial (8) Oracle modified character Set
1. Connect the database with the DBA
-->sqlplus/as SYSDBA
2. View Character Set
--SELECT parameter, value from v$nls_parameters WHERE parameter like '%characterset ';
As if the result:
PARAMETER----------------------------------------------------------------VALUE------------------------------------------- ---------------------Nls_charactersetzhs16gbknls_nchar_charactersetal16utf16
3. Modify the character set
Set Internal_use Al32utf8;
4, the specific command execution process:
C:\users\administrator>sqlplus/As sysdbasql*plus:release11.2.0.1.0 Production onSunday July 3 13:11:46 2016Copyright(c) 1982, Oracle. All rights reserved.Connect to: Oracle Database 11g Enterprise Edition Release11.2.0.1.0-64bit Productionwith the partitioningOlapData Mining and Real application testing Optionssql>SQL>SELECTparameter, value from v$nls_parameters WHERE parameter like '%characterset ';PARAMETER----------------------------------------------------------------VALUE--------------------------------------- -------------------------Nls_charactersetzhs16gbknls_nchar_charactersetal16utf16sql> Shutdown Immediate;The database is closed. The database has been uninstalled. The ORACLE routine has been closed. SQL>SQL>SQL> Startup mount;The ORACLE routine has been started. Total System Global Area855982080bytesfixed Size2180544bytesvariable Size528484928Bytesdatabasebuffers322961408Bytesredobuffers2355200The bytes database is loaded. SQL>SQL> Alter SESSIONSetSql_trace=true;The session has changed. SQL> alter system enable RESTRICTED SESSION;The system has changed. SQL> Alter systemSetjob_queue_processes=0;The system has changed. SQL> Alter systemSetaq_tm_processes=0;The system has changed. SQL> ALTER DATABASE open;The database has changed. SQL> ALTER DATABASE characterSetInternal_use Al32utf8;The database has changed. SQL> Alter SESSIONSetSql_trace=false;The session has changed. SQL> Shutdown Immediate;The database is closed. The database has been uninstalled. The ORACLE routine has been closed. SQL> Startup;The ORACLE routine has been started. Total System Global Area855982080bytesfixed Size2180544bytesvariable Size528484928Bytesdatabasebuffers322961408Bytesredobuffers2355200The bytes database is loaded. The database is already open. SQL>SELECTparameter, value from v$nls_parameters WHERE parameter like '%characterset ';PARAMETER--------------------------------------------------------------------------------VALUE----------------------- ---------------------------------------------------------Nls_charactersetal32utf8nls_nchar_ Charactersetal16utf16sql>
Oracle Basic Tutorial (8) Oracle modified character Set