oracle10g_csscan_更變資料庫字符集及國家字符集的工具測試

1,先在轉換字符集及國家字符集前作個資料庫backup
2,csscan userid=system/system full=y
  執行這個命令可能會提示
CSSCAN \"sys/password@db10g AS SYSDBA\" FULL=Y

Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on Tue Dec 5 06:54:23 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
CSS-00107: Character set migration utility schema not installed

Scanner terminated unsuccessfully.

C:\>
3,解決以上執行以下：
  The character set migration utility schema is installed by running the
 "$ORACLE_HOME/rdbms/admin/csminst.sql" script. in SQL*Plus as the SYS
user.
4，然後再執行csscan userid=system/system full=y --此可以互動式或者提供相關引數
5,shutdown immediate
6,startup restrict
7,@@csalter.plb  --$ORACLE_HOME/rdbms/admin
8,shutdown immediate
9,startup