1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
从A库表重复更新B库表的两种思路 思路1:每次清空B库表中的数据再insert; 思路2:每次都drop掉表再insert; 由于业务需求频繁变化,A库中的表可能会经常调整结构,因此我们采用每次都drop掉表再insert的方式、减少工作量! ----------思路1举例: --先清理数据再insert的方式(请勿删除,以备后用!) --清空数据 truncate table "DW2"."ZCRM_CUSTOMER" ; truncate table "DW2"."ZCRM_MATERIAL" ; truncate table "DW2"."ZCRM_ORDER" ; --插入数据 insert into "DW2"."ZCRM_CUSTOMER" select * from "DW1"."ZCRM_CUSTOMER"; insert into "DW2"."ZCRM_MATERIAL" select * from "DW1"."ZCRM_MATERIAL"; insert into "DW2"."ZCRM_ORDER" select * from "DW1"."ZCRM_ORDER"; ----------思路2举例: --每次都drop掉表再insert的方式 --drop表 drop table "DW2"."ZCRM_CUSTOMER" ; drop table "DW2"."ZCRM_MATERIAL" ; drop table "DW2"."ZCRM_ORDER" ; --create table select from... create table "DW2"."ZCRM_CUSTOMER" as ( SELECT * FROM "DW1"."ZCRM_CUSTOMER") ; create table "DW2"."ZCRM_MATERIAL" as ( SELECT * FROM "DW1"."ZCRM_MATERIAL") ; create table "DW2"."ZCRM_ORDER" as ( SELECT * FROM "DW1"."ZCRM_ORDER") ; |
本文作者: GavinDong
版权属于: GavinDong博客
文章链接: https://gavindong.com/2646.html
如果使用过程中遇到问题,可 **点击此处** 交流沟通。
版权所有,转载时必须以链接形式注明作者和原始出处及本声明。