修改 oracle数据库 字符集

xinjiang

　　SQL> select userenv('language') from dual;
　　USERENV('LANGUAGE')
　　----------------------------------------------------
　　AMERICAN_AMERICA.WE8ISO8859P1
　　SQL> select userenv('language') from dual;
　　USERENV('LANGUAGE')
　　----------------------------------------------------
　　AMERICAN_AMERICA.WE8ISO8859P1
　　SQL> shutdown immetiate;
　　SP2-0717: illegal SHUTDOWN option
　　SQL> shutdown immediate;
　　Database closed.
　　Database dismounted.
　　ORACLE instance shut down.
　　SQL> startup mount;
　　ORACLE instance started.
　　Total System Global Area 1828716544 bytes

　　Fixed>
　　Variable>　　Database Buffers 1392508928 bytes
　　Redo Buffers 14753792 bytes
　　Database mounted.

　　SQL>>
　　System>
　　SQL>>
　　System>
　　SQL>>
　　System>
　　SQL>>
　　Database>
　　SQL>>
　　Database>　　SQL> select userenv('language') from dual;
　　USERENV('LANGUAGE')
　　----------------------------------------------------
　　AMERICAN_AMERICA.AL32UTF8
　　SQL> select userenv('language') from dual;
　　USERENV('LANGUAGE')
　　----------------------------------------------------
　　AMERICAN_AMERICA.AL32UTF8
　　SQL> shutdown immetiate;
　　SP2-0717: illegal SHUTDOWN option
　　SQL> shutdown immediate;
　　Database closed.
　　Database dismounted.
　　ORACLE instance shut down.
　　SQL> startup;
　　ORACLE instance started.
　　Total System Global Area 1828716544 bytes

　　Fixed>
　　Variable>　　Database Buffers 1392508928 bytes
　　Redo Buffers 14753792 bytes
　　Database mounted.
　　Database opened.
　　SQL> select userenv('language') from dual;
　　USERENV('LANGUAGE')
　　----------------------------------------------------
　　AMERICAN_AMERICA.AL32UTF8