10g中如何修改数据库字符集-3

[oracle@roger ~]$

scan默认会将扫描相关的信息写入到一个试图scm$parameters中，查询如下：

SQL> select * from csm$parameters;

NAME                           VALUE

--------------------------------------------------------------------------------

SCANNER_VERSION                5

SCAN_TYPE                      ALL

SCAN_CHAR                      YES

TO_CHARSET_NAME                ZHS16GBK

FROM_CHARSET_NAME              WE8ISO8859P1

SCAN_NCHAR                     NO

MAX_ARRAY_SIZE                 1024000

MAX_ROWS_IN_HEAP               100

NUMBER_OF_PROCESS              1

SUPPRESS_ERROR_LOG_BY          -1

INSERT_SUPPRESSED              NO

CAPTURE_CONVERTIBLE_DATA       NO

SCANNER_SCRIPT                 NO

SCANNER_PRESERVE               NO

MIGRATE_TO_SUPERSET            0

CSLD_ENABLE                    0

PREVIOUS_CHARACTER_SET         WE8ISO8859P1

PREVIOUS_NCHAR_SET             AL16UTF16

TIME_START                     2011-07-04 16:29:44

TIME_END                       2011-07-04 16:32:44

20 rows selected.

另外补充一下的是，scan默认也会生成几个scan扫描的结果文件，如下：

[oracle@roger ~]$ ls -ltr scan*

-rwxrwxrwx  1oracle dba   444 Nov 28  2010 scan.sh

-rw-r--r--  1oracle dba  8239 Jul  4 16:32 scan.txt

-rw-r--r--  1oracle dba 75329 Jul  4 16:32 scan.out

-rw-r--r--  1oracle dba  1878 Jul  4 16:32 scan.err

[oracle@roger ~]$ cat scan.err

Database Scan Individual Exception Report

[Database Scan Parameters]

Parameter                      Value                                          

------------------------------------------------------------------------------

CSSCAN Version                 v2.1                                           

Instance Name                  roger                                          

Database Version               10.2.0.4.0                                     

Scan type                      Full database                                  

Scan CHAR data?                YES                                            

Database character set         WE8ISO8859P1                                   

FROMCHAR                       WE8ISO8859P1                                   

TOCHAR                         ZHS16GBK                                       

Scan NCHAR data?               NO                                             

Array fetch buffer size        1024000                                        

Number of processes            1                                              

Capture convertible data?      NO                                             

------------------------------------------------------------------------------

[Data Dictionary individual exceptions]

[Application data individual exceptions]

User  : ROGER

Table : HT01

Column: NAME

Type  :VARCHAR2(6)

Number of Exceptions         : 2        

Max Post Conversion Data Size: 8        

ROWID             Exception Type      Size CellData(first 30 bytes)    

------------------ ------------------ -----------------------------------

AAAMrNAAFAAAAAMAAA exceed column size     8 靠靠                         

AAAMrNAAFAAAAAMAAB exceed column size     8 靠靠                         

------------------ ------------------ -----------------------------------

转载于:https://www.cnblogs.com/ebs-blog/archive/2011/07/19/2167238.html