oracle修改字符集的小工具csscan
来源:互联网 发布:小额贷款公司记账软件 编辑:程序博客网 时间:2024/04/27 20:42
oracle修改字符集的小工具csscan
1.首先以sys用户身份创建用户(CSMIG)和相应的数据字典视图
SQL> conn /as sysdba
Connected.
SQL> @?/rdbms/admin/csminst.sql
User created.
Grant succeeded.
Grant succeeded.
Grant succeeded.
User altered.
1 row created.
1 row updated.
Connected.
......
Commit complete.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
$
建立用户scott和demo表用来做测试,数据量小点,速度快些。
SQL> conn /as sysdba
Connected.
SQL> grant connect,resource to scott identified by tiger;
Grant succeeded.
SQL> conn scott/tiger
Connected.
SQL> @?/sqlplus/demo/demobld.sql
Building demonstration tables. Please wait.
Demonstration table build is complete.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
$
2.脚本执行完成之后,执行csscan符集扫描工具,并查看输出报告
$ csscan system/manager
Character Set Scanner v1.1 : Release 9.2.0.1.0 - Production on Tue May 27 10:51:57 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
(1)Full database, (2)User, (3)Table: 1 > 2
Current database character set is WE8ISO8859P1.
Enter new database character set name: > WE8ISO8859P1
Enter array fetch buffer size: 10240 > 1024000
Enter number of scan processes to utilize(1..32): 1 > 2
Enter user name to scan: > scott
Enumerating tables to scan... --开始扫描,如果数据量大,会很慢
. process 1 scanning SCOTT.EMP[AAAi+sAABAAALKZAAA]
. process 1 scanning SCOTT.DEPT[AAAi+tAABAAALKpAAA]
. process 1 scanning SCOTT.BONUS[AAAi+uAABAAALK5AAA]
Creating Database Scan Summary Report...
Creating Individual Exception Report...
Scanner terminated successfully.
$
$ ls -otr scan*
-rw-r--r-- 1 oracle 5803 May 27 11:06 scan.txt
-rw-r--r-- 1 oracle 869 May 27 11:06 scan.out
-rw-r--r-- 1 oracle 1117 May 27 11:06 scan.err
$
$ more scan.err
Database Scan Individual Exception Report
[Database Scan Parameters]
Parameter Value
------------------------------ ------------------------------------------------
Scan type User tables
User name scott
Scan CHAR data? YES
Current database character set WE8ISO8859P1
New database character set WE8ISO8859P1
Scan NCHAR data? NO
Array fetch buffer size 1024000
Number of processes 2
Capture convertible data? NO
------------------------------ ------------------------------------------------
[Data Dictionary individual exceptions]
[Application data individual exceptions]
$
$ more scan.txt
Database Scan Summary Report
Time Started : 2008-05-27 11:06:02
Time Completed: 2008-05-27 11:06:06
Process ID Time Started Time Completed
---------- -------------------- --------------------
1 2008-05-27 11:06:06 2008-05-27 11:06:06
---------- -------------------- --------------------
[Database Size]
Tablespace Used(MB) Free(MB) Total(MB)
------------------------------ --------------- --------------- ---------------
SYSTEM 346.000 54.000 400.000
TOOLS 112.000 5.000 117.000
......
3.最后看看它的帮助说明
$ csscan -help
Character Set Scanner v1.1 : Release 9.2.0.1.0 - Production on Tue May 27 11:10:00 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
You can let Scanner prompt you for parameters by entering the CSSCAN
command followed by your username/password:
Example: CSSCAN SYSTEM/MANAGER
Or, you can control how Scanner runs by entering the CSSCAN command
followed by various parameters. To specify parameters, you use keywords:
Example: CSSCAN SYSTEM/MANAGER FULL=y TOCHAR=utf8 ARRAY=102400 PROCESS=3
Keyword Default Prompt Description
---------- ------- ------ -------------------------------------------------
USERID yes username/password
FULL N yes scan entire database
USER yes user name of the table to scan
TABLE yes list of tables to scan
EXCLUDE list of tables to exclude from scan
TOCHAR yes new database character set name
FROMCHAR current database character set name
TONCHAR new NCHAR character set name
FROMNCHAR current NCHAR character set name
ARRAY 10240 yes size of array fetch buffer
PROCESS 1 yes number of scan process
MAXBLOCKS split table if larger than MAXBLOCKS
CAPTURE N capture convertible data
SUPPRESS suppress error log by N per table
FEEDBACK feedback progress every N rows
BOUNDARIES list of column size boundaries for summary report
LASTRPT N generate report of the last database scan
LOG scan base name of log files
PARFILE parameter file name
PRESERVE N preserve existing scan results
HELP N show help screen (this screen)
---------- ------- ------ -------------------------------------------------
Scanner terminated successfully.
$
- oracle修改字符集的小工具csscan
- oracle修改字符集的小工具csscan
- oracle关于字符集的两个小工具
- oracle关于字符集的两个小工具
- 利用csscan转换ORACLE数据库的字符集
- 一个文件修改监视的小工具
- 修改oracle的字符集
- 修改Oracle的字符集
- 修改oracle的字符集
- 字符集扫描工具csscan
- WordPress修改功能小工具
- 小工具批量修改名字
- 修改WordPress自带的小工具(Widget)
- Java多线程处理百万数据修改的小工具项目
- 方便的小工具
- xorg的小工具
- 有意思的小工具
- 整理的小工具
- 堆排序 O(nlgn)
- 开始-运行输入
- 获取本机通讯录中的内容,解析通讯录源代码
- SQLServer 中查询所有表及其字段
- select count(column_name) form table_name or select count(*) from table_Name
- oracle修改字符集的小工具csscan
- use python to sendmail
- 多人在线游戏开发心得(服务器端)
- 安卓自测试题——第十三期
- 百度二面
- JBoss ${jboss.bind.address}
- 学习JPA——Hibernate Annotation使用实例
- hdu1196
- ssh互信失败的一个最主要的原因是.ssh目录的权限没有设置正确