Csscan 输出结果解释及函数参考
1星 需积分: 10 162 浏览量
更新于2024-07-26
收藏 142KB PDF 举报 CSscan 报告和函数参考
CSscan 是一个 Oracle 数据库字符集转换工具，用于将数据库从一种字符集转换到另一种字符集。下面是 CSscan 的知识点总结：
**CSscan 输出文件**
CSscan 生成三种类型的输出文件：
1. outfile：包含转换结果的详细信息。
2. txtfile：包含转换结果的摘要信息。
3. errfile：包含转换过程中的错误信息。
**CSscan 输出文件中的状态信息**
在 txtfile 文件中，CSscan 会报告转换结果的状态信息，包括：
1. CHANGELESS 数据：表示数据没有任何变化。
2. CONVERTIBLE 数据：表示数据可以被转换，但可能会丢失一些信息。
3. TRUNCATION 数据：表示数据被截断，以适应目标字符集的限制。
4. LOSSY 数据：表示数据会丢失一些信息，可能需要手动干预。
**处理 LOSSY 数据**
如果出现 LOSSY 数据，可能是因为：
1. 目标字符集中没有对应的字符。
2. 源数据库中的数据使用了未定义的字符集。
3. CSscan 无法检测到的损失数据。
解决方法包括：
1. 使用 FULL EXP/IMP 将数据库导出到新的字符集。
2. 使用 ALTER DATABASE CHARACTER SET 命令更改数据库字符集。
3. 使用 CSalter 工具来更改字符集。
**CSscan 的使用**
使用 CSscan 需要注意以下几点：
1. 不需要总是运行完整的数据库扫描，可以使用 EXCLUDE, USER 或 TABLE 参数来限制扫描范围。
2. 在更改 NLS_CHARACTERSET 时，需要指定 TOCHAR 和 FROMCHAR parameters。
3. 可以指定 TOCHAR=AL16UTF16，以便将数据库字符集更改为 AL16UTF16。
**CSscan 的优点**
使用 CSscan 可以：
1. 轻松地将数据库字符集从一种字符集转换到另一种字符集。
2. 检测和解决转换过程中的问题。
3. 提高数据库的可移植性和兼容性。
CSscan 是一个功能强大且灵活的工具，可以帮助数据库管理员轻松地将数据库字符集进行转换，提高数据库的可移植性和兼容性。
[Distribution of Convertible Data per Column]
USER.TABLE|COLUMN Convertible Truncation Lossy
-------------------------------------------------- ---------------- ---------------- ----------------
ACEREP.CXCOPYLOGMSG|MESSAGE 0 0 4
ACEREP.CXEXP|EXPSTRING 0 0 10
ACEREP.CXEXPORTLOGMSG|MESSAGE 0 0 1
ACEREP.CXKBSBLOB|KBSBLOB 0 0 23
ACEREP.CXPURGEKBSELEMENT043004|PURGE_LOG 17,804 0 0
...
SYS.HISTGRM$|EPVALUE 0 0 6
SYS.METASTYLESHEET|STYLESHEET 58 0 0
SYS.RULE$|CONDITION 23 0 0
SYS.SOURCE$|SOURCE 0 0 147
-------------------------------------------------- ---------------- ---------------- ----------------
[Indexes to be Rebuilt]
USER.INDEX on USER.TABLE(COLUMN)
-----------------------------------------------------------------------------------------
APPLSYS.FND_CONCURRENT_PROGRAMS_TL_U2 on APPLSYS.FND_CONCURRENT_PROGRAMS_TL(APPLICATION_ID)
...
GCTA.COUNTRY_CODE_IDX on GCTA.CFI_HTS_MASS_APPROVE(COUNTRY_CODE)
-----------------------------------------------------------------------------------------
The .txt file shows:
Time Started / Time Completed: duration of the Csscan run. Csscan will do a fetch of all character data, so running time is
in most cases at least the time to do a full export.
[Database Size]: the size of the data within the database, the
Expansion
column (if applicable) gives an
estimation
on how
much more place you need in the current tablespace when going to the new characterset. The Tablespace Expansion for
tablespace X is calculated as the grand total of the differences between the byte length of a string converted to the target
character set and the original byte length of this string over all strings scanned in tables in X. The distribution of values in blocks,
PCTFREE, free extents, etc., are not taken into account.
[Database Scan Parameters]: the parameters used to run Csscan
[Scan Summary]: which gives you directly an idea if you can do a full exp/imp, use Csalter or "Alter Database Character Set"
as described in point D)
[Data Dictionary Conversion Summary]: gives an overview of the amount of Changeless, Convertible, Truncation or Lossy
data there is in the Data Dictionary.
[Application Data Conversion Summary]: gives an overview of the amount of Changeless, Convertible, Truncation or Lossy
data there is in User data.
[Distribution of Convertible Data per Table]: gives a breakdown on table basis.
[Distribution of Convertible Data per Column]: gives a breakdown on column basis.
[Indexes to be Rebuilt]: gives which indexes are going to be affected by convertible data. The name of the section is bit
misleading. When using full export/import there nothing to do on those indexes. When using Cslater/alter database characterset
together with a partial export/import it depends on the amount of 'convertible' data in the underlying columns. If only a few rows
in the underlying columns are 'convertible' then there is nothing to do (the indexes do not need to be rebuild as such). But if you
have a lot of 'convertible' data in underlying columns it might be a good idea to drop and recreate them after the import, simply
for performance reasons. The only exception is an index on a CHAR/NCHAR column that you need to adapt for "truncation". In
that case all key values of a CHAR/NCHAR index key have to be padded with blanks to the new length and it may be more
efficient to drop and recreate the index.
[Truncation Due To Character Semantics]: (not often seen) This can be seen if you use Char Semantics in the current
database.The Truncation Due to Character Semantics section identifies the number of data cells that would be truncated if they
were converted to the target character set (for example, by the SQL CONVERT function or another inline conversion process)
before the database character set is updated with the Csalter script. If the data conversion occurs after the database character
set is changed (= you use export/import for convertible data), then this section can be ignored.
A.3) The .err file.
The output in the .err file depends on the CAPTURE=Y or CAPTURE=N Csscan parameter.
If you use CAPTURE=N then the .err file will only log rows who are Lossy or Truncation. Convertible data is not logged in the .err
file.
If you use CAPTURE=Y then the .err file will log rows who are Convertible, Lossy or Truncation. Using CAPTURE=Y may also
increase the running time of csscan (and the space needed for the csmig tables) if there are a lot of 'Convertible' entry's, seen for
every 'Convertible' row an insert is done in a table in the csmig schema.
The SUPPRESS parameter limits the size of the .err file by limiting the amount of information logged for a table. Using SUPPRESS=1000
will log max 1000 rows for a table in the .err file and also reduce the space needed for the csscan Csmig tables.
It will not affect the information in the .txt file.
This parameter may be useful for the first scan done on big databases to limit the size of the .err file and the Csmig tables.
Document Display https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx...
4／16 2013/1/15 下午 10:18
剩余15页未读，继续阅读
2019-06-27 上传
点击了解资源详情
2024-11-14 上传
2024-11-14 上传
starapartment
- 粉丝: 0
- 资源: 2
我的内容管理
展开
最新资源
- 高清艺术文字图标资源，PNG和ICO格式免费下载
- mui框架HTML5应用界面组件使用示例教程
- Vue.js开发利器：chrome-vue-devtools插件解析
- 掌握ElectronBrowserJS：打造跨平台电子应用
- 前端导师教程：构建与部署社交证明页面
- Java多线程与线程安全在断点续传中的实现
- 免Root一键卸载安卓预装应用教程
- 易语言实现高级表格滚动条完美控制技巧
- 超声波测距尺的源码实现
- 数据可视化与交互：构建易用的数据界面
- 实现Discourse外聘回复自动标记的简易插件
- 链表的头插法与尾插法实现及长度计算
- Playwright与Typescript及Mocha集成：自动化UI测试实践指南
- 128x128像素线性工具图标下载集合
- 易语言安装包程序增强版：智能导入与重复库过滤
- 利用AJAX与Spotify API在Google地图中探索世界音乐排行榜
