Oracle技术：如何修改oracle数据库字符集的方法

会计考友

>sqlplus "/ as sysdba" 　　SQL*Plus: Release 9.2.0.4.0 - Production on Sat Nov 1 10:52:30 2003
  @! g% {' R+ |; }9 r# L! @  y  q3 o　　Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
　　Connected to:
" k8 i' X5 c+ i& C; a　　Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
　　With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
　　JServer Release 9.2.0.4.0 - Production
( N) M/ Z$ G0 Y* U　　SQL> shutdown immediate
0 ]5 M; K$ T9 e# b' L　　Database closed.
　　Database dismounted.
1 `2 k" |; g, J4 l# H' h　　ORACLE instance shut down.
　　SQL> STARTUP MOUNT;
　　ORACLE instance started.
3 p. Q0 s  O1 h0 f　　Total System Global Area   76619308 bytes
　　Fixed Size                   454188 bytes
　　Variable Size              58720256 bytes
  n$ K. }) C( f) B4 G+ G　　Database Buffers           16777216 bytes
　　Redo Buffers                 667648 bytes
　　Database mounted.
　　SQL> ALTER SESSION SET SQL_TRACE=TRUE;
: C* t' y2 W# c　　Session altered.
& t) K/ n7 a" t0 Z: Y　　SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
! t! c# i; \* z) f　　System altered.
# W# Y  i' n  b7 v4 K$ ?　　SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
; s( _: r# ~# A6 j　　System altered.
, G& j2 I7 R- a; N1 E　　SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
　　System altered.
　　SQL> ALTER DATABASE OPEN;
　　Database altered.
　　SQL> set linesize 120;
7 a" S7 c0 |9 n/ j　　SQL> alter database character set zhs16gbk;
　　alter database character set zhs16gbk