文件名称:数据库优化--局部数据迁移结果验证
文件大小:41KB
文件格式:ZIP
更新时间:2015-04-10 11:43:55
oracle 数据迁移 数据优化 SQl脚本 数据验证
1、data_conf数据比较脚本(组织关系表的数据比较,业务数据比较); 2、table_analysis数据表分析结果统计; 3、table_info数据表信息获取(普通数据表的表结构信息获取,分区数据表的分区数据信息获取)。
【文件预览】:
TransplantCheckSQL
----table_analysis()
--------table_analysis_info.bat(2KB)
--------table_analysis_info.sql(2KB)
----table_info()
--------integrated()
--------normal()
----data_conf()
--------data_stat_drive_info_count_month.sql(3KB)
--------data_stat_drive_work_viol_count_fuel.sql(841B)
--------data_stat_drive_work_viol_count_mb_record.sql(13KB)
--------data_stat_drive_info_count_day.sql(6KB)
--------data_stat_drive_work_viol_count_driveday.sql(625B)
--------data_stat_gas_up_info.sql(962B)
--------data_stat_drive_work_viol_count_sc_record.sql(12KB)
--------data_stat_drive_work_viol_count_ce_dirvecnt.sql(757B)
--------data_stat_drive_work_viol_count_v_record.sql(16KB)
--------data_stat_drive_work_viol_count_br_record.sql(14KB)
--------data_stat_drive_work_viol_count.sql(11KB)
--------data_stat_drive_work_viol_count_v_record_org.sql(3KB)
--------data_organization_info_all_org_v.sql(5KB)
--------data_conf_run.bat(2KB)
--------data_stat.bat(11KB)
--------data_stat_drive_work_viol_count_ce_record.sql(15KB)
--------data_stat_drive_work_viol_count_ce.sql(11KB)
--------data_organization_info_all_org.sql(6KB)
--------data_organization_info.sql(3KB)
--------data_stat_drive_work_viol_count_br.sql(11KB)
--------data_stat_gas_up_info_record.sql(5KB)
--------data_stat_drive_work_viol_count_mbsc.sql(11KB)
--------data_organization_info.bat(4KB)
--------data_stat_drive_work_viol_count_v.sql(11KB)