Oracle 视图 DBA_COMPARISON_SCAN_VALUES 官方解释,作用,如何使用详细说明
本站中文解释
DBA_COMPARISON_SCAN_VALUES是一个Oracle视图,它用于比较两个数据库(或者说是两个实例)之间的表结构和数据是否一致。
它的内容包括比较前表的基本信息(数据库名、表名、行数、列数), 表数据是否一致,每行数据是否一致等。
使用方法:
(1)检查表结构:通过查询数据库中的DBA_COMPARISON_SCAN_VALUES视图,比较两个数据库中表的结构是否完全一致:
SELECT * FROM DBA_COMPARISON_SCAN_VALUES where comparison_scan_name=’表结构比较名称’;
(2)检查表数据比较:通过查询数据库中的DBA_COMPARISON_SCAN_VALUES视图,比较两个数据库中表的数据是否完全一致:
SELECT * FROM DBA_COMPARISON_SCAN_VALUES where comparison_scan_name=’表数据比较名称’;
官方英文解释
DBA_COMPARISON_SCAN_VALUES
displays information about the values for all comparison scans in the database.
Related View
USER_COMPARISON_SCAN_VALUES
displays information about the values for the comparison scans owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the comparison scan |
|
|
|
Name of the comparison scan |
|
|
|
Scan ID |
|
|
|
Column position, as in |
|
|
Minimum value of the scan |
|
|
|
Maximum value of the scan |
|
|
|
Time that this row was last updated |
See Also:
“USER_COMPARISON_SCAN_VALUES”