|
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") ; |