– 数据同步前置条件

ALTER TABLE APP ADD CREATE_TIME TIMESTAMP(6); COMMENT ON COLUMN APP.CREATE_TIME IS ‘创建时间’; ALTER TABLE APP ADD UPDATE_TIME TIMESTAMP(6); COMMENT ON COLUMN APP.UPDATE_TIME IS ‘修改时间’;

ALTER TABLE REG_USER ADD CREATE_TIME TIMESTAMP(6); COMMENT ON COLUMN REG_USER.CREATE_TIME IS ‘创建时间’; ALTER TABLE REG_USER ADD UPDATE_TIME TIMESTAMP(6); COMMENT ON COLUMN REG_USER.UPDATE_TIME IS ‘修改时间’;

ALTER TABLE TRAID_PERSON ADD CREATE_TIME TIMESTAMP(6); COMMENT ON COLUMN TRAID_PERSON.CREATE_TIME IS ‘创建时间’; ALTER TABLE TRAID_PERSON ADD UPDATE_TIME TIMESTAMP(6); COMMENT ON COLUMN TRAID_PERSON.UPDATE_TIME IS ‘修改时间’;

ALTER TABLE TRIAD_DEPT ADD CREATE_TIME TIMESTAMP(6); COMMENT ON COLUMN TRIAD_DEPT.CREATE_TIME IS ‘创建时间’; ALTER TABLE TRIAD_DEPT ADD UPDATE_TIME TIMESTAMP(6); COMMENT ON COLUMN TRIAD_DEPT.UPDATE_TIME IS ‘修改时间’;

ALTER TABLE TRIAD_ENTERPRISE_INFO ADD CREATE_TIME TIMESTAMP(6); COMMENT ON COLUMN TRIAD_ENTERPRISE_INFO.CREATE_TIME IS ‘创建时间’; ALTER TABLE TRIAD_ENTERPRISE_INFO ADD UPDATE_TIME TIMESTAMP(6); COMMENT ON COLUMN TRIAD_ENTERPRISE_INFO.UPDATE_TIME IS ‘修改时间’;

ALTER TABLE TRIAD_MYSELF_INFO ADD CREATE_TIME TIMESTAMP(6); COMMENT ON COLUMN TRIAD_MYSELF_INFO.CREATE_TIME IS ‘创建时间’; ALTER TABLE TRIAD_MYSELF_INFO ADD UPDATE_TIME TIMESTAMP(6); COMMENT ON COLUMN TRIAD_MYSELF_INFO.UPDATE_TIME IS ‘修改时间’;

ALTER TABLE WEBSITE ADD CREATE_TIME TIMESTAMP(6); COMMENT ON COLUMN WEBSITE.CREATE_TIME IS ‘创建时间’; ALTER TABLE WEBSITE ADD UPDATE_TIME TIMESTAMP(6); COMMENT ON COLUMN WEBSITE.UPDATE_TIME IS ‘修改时间’;

 SELECT SYSDATE INTO :NEW.UPDATE_TIME FROM DUAL; ELSE SELECT SYSDATE INTO :NEW.CREATE_TIME FROM DUAL; 

END IF; END;

讯享网 SELECT SYSDATE INTO :NEW.UPDATE_TIME FROM DUAL; ELSE SELECT SYSDATE INTO :NEW.CREATE_TIME FROM DUAL; 

END IF; END;

讯享网

 SELECT SYSDATE INTO :NEW.UPDATE_TIME FROM DUAL; ELSE SELECT SYSDATE INTO :NEW.CREATE_TIME FROM DUAL; 

END IF; END;

讯享网 SELECT SYSDATE INTO :NEW.UPDATE_TIME FROM DUAL; ELSE SELECT SYSDATE INTO :NEW.CREATE_TIME FROM DUAL; 

END IF; END;

 SELECT SYSDATE INTO :NEW.UPDATE_TIME FROM DUAL; ELSE SELECT SYSDATE INTO :NEW.CREATE_TIME FROM DUAL; 

END IF; END;

讯享网 SELECT SYSDATE INTO :NEW.UPDATE_TIME FROM DUAL; ELSE SELECT SYSDATE INTO :NEW.CREATE_TIME FROM DUAL; 

END IF; END;

 SELECT SYSDATE INTO :NEW.UPDATE_TIME FROM DUAL; ELSE SELECT SYSDATE INTO :NEW.CREATE_TIME FROM DUAL; 

END IF; END;

CREATE TABLE APP_UP AS SELECT * FROM APP WHERE 1=2; CREATE TABLE REG_USER_UP AS SELECT * FROM REG_USER WHERE 1=2; CREATE TABLE TRAID_PERSON_UP AS SELECT * FROM TRAID_PERSON WHERE 1=2; CREATE TABLE TRIAD_DEPT_UP AS SELECT * FROM TRIAD_DEPT WHERE 1=2; CREATE TABLE TRIAD_ENTERPRISE_INFO_UP AS SELECT * FROM TRIAD_ENTERPRISE_INFO WHERE 1=2; CREATE TABLE TRIAD_MYSELF_INFO_UP AS SELECT * FROM TRIAD_MYSELF_INFO WHERE 1=2; CREATE TABLE WEBSITE_UP AS SELECT * FROM WEBSITE WHERE 1=2;

– 最后执行 更新数据合并 MERGE INTO APP A USING APP_UP B ON (A.ID = B.ID) WHEN MATCHED THEN UPDATE SET A.NAME= B.NAME,A.ICP_RECORD_CODE= B.ICP_RECORD_CODE,A.DEVELOPER_NAME= B.DEVELOPER_NAME,A.APP_VERSION= B.APP_VERSION,A.OPEN_DATE= B.OPEN_DATE,A.ADD_TIME= B.ADD_TIME,A.JOIN_AREA_RULE= B.JOIN_AREA_RULE,A.PROVINCE_CODE= B.PROVINCE_CODE,A.CITY_CODE= B.CITY_CODE,A.AREA_CODE= B.AREA_CODE,A.JOIN_NAME= B.JOIN_NAME,A.JOIN_TYPE= B.JOIN_TYPE,A.IF_SERVICE_INTERACTIVE= B.IF_SERVICE_INTERACTIVE,A.IF_SERVICE_FORUM= B.IF_SERVICE_FORUM,A.SERVICE_CONTENT= B.SERVICE_CONTENT,A.IF_INFORMATION_SERVICE= B.IF_INFORMATION_SERVICE,A.INFORMATION_CONTENT= B.INFORMATION_CONTENT,A.IF_FRONT_ACCESS= B.IF_FRONT_ACCESS,A.ACCESS_CONTENT= B.ACCESS_CONTENT,A.LANGUAGE= B.LANGUAGE,A.NEWS= B.NEWS,A.PUBLISH= B.PUBLISH,A.EDUCATION= B.EDUCATION,A.SPORTS= B.SPORTS,A.MEDICAL= B.MEDICAL,A.OTHER= B.OTHER,A.BUSINESS_TYPE= B.BUSINESS_TYPE,A.WEBSITE_TYPE= B.WEBSITE_TYPE,A.REG_USER_ID= B.REG_USER_ID,A.URGENT_CONTACTS_NAME1= B.URGENT_CONTACTS_NAME1,A.URGENT_CONTACTS_IDTYPE1= B.URGENT_CONTACTS_IDTYPE1,A.URGENT_CONTACTS_IDCODE1= B.URGENT_CONTACTS_IDCODE1,A.URGENT_CONTACTS_PHONE1= B.URGENT_CONTACTS_PHONE1,A.URGENT_CONTACTS_NAME2= B.URGENT_CONTACTS_NAME2,A.URGENT_CONTACTS_IDTYPE2= B.URGENT_CONTACTS_IDTYPE2,A.URGENT_CONTACTS_IDCODE2= B.URGENT_CONTACTS_IDCODE2,A.URGENT_CONTACTS_PHONE2= B.URGENT_CONTACTS_PHONE2,A.IF_MULTI_MEDIA= B.IF_MULTI_MEDIA,A.APP_AREA_CODE= B.APP_AREA_CODE,A.POLICE_RECORD_CODE= B.POLICE_RECORD_CODE,A.IF_NEWSMEDIA= B.IF_NEWSMEDIA,A.NEWMEDIA_CODE= B.NEWMEDIA_CODE,A.NEWMEDIA_TYPE= B.NEWMEDIA_TYPE,A.NEWMEDIA_FILEPATH= B.NEWMEDIA_FILEPATH,A.IF_DANGEROUS_EXPLOSION= B.IF_DANGEROUS_EXPLOSION,A.MAIN_DOMAIN= B.MAIN_DOMAIN,A.IPS= B.IPS,A.TYPE_CONTENT= B.TYPE_CONTENT,A.WEBSITE_COUNTRY= B.WEBSITE_COUNTRY,A.WEBSITE_ADDRESS= B.WEBSITE_ADDRESS,A.ISCDN= B.ISCDN,A.SERVICE_NAME= B.SERVICE_NAME,A.DOMAIN_COUNTRY= B.DOMAIN_COUNTRY,A.DOMAIN_ADDRESS= B.DOMAIN_ADDRESS,A.POLICE_CODE= B.POLICE_CODE,A.POLICE_NAME= B.POLICE_NAME,A.STATE= B.STATE,A.CHECK_DATE= B.CHECK_DATE,A.CHECK_PERSON= B.CHECK_PERSON,A.CHECK_PASS= B.CHECK_PASS,A.NO_PASS_REASON= B.NO_PASS_REASON,A.PASSWORD= B.PASSWORD,A.IF_REGISTER_FUN= B.IF_REGISTER_FUN,A.USERNAME= B.USERNAME,A.ICON= B.ICON,A.DANGEROUS_TYPE= B.DANGEROUS_TYPE,A.INFOPROCESS_PATH= B.INFOPROCESS_PATH,A.IP_STATE= B.IP_STATE,A.IP_ADDRESS= B.IP_ADDRESS,A.IPV6= B.IPV6,A.UPDATE_TIME= B.UPDATE_TIME,A.ICP_RECORD_CODE_NUMA= B.ICP_RECORD_CODE_NUMA,A.ICP_RECORD_CODE_NUMB= B.ICP_RECORD_CODE_NUMB,A.ICP_RECORD_CODE_NUMAB= B.ICP_RECORD_CODE_NUMAB,A.DATA_SOURCE= B.DATA_SOURCE,A.NO_NEWMEDIA_FILEPATH= B.NO_NEWMEDIA_FILEPATH,A.CREATE_TIME= B.CREATE_TIME; MERGE INTO REG_USER A USING REG_USER_UP B ON (A.ID = B.ID) WHEN MATCHED THEN UPDATE SET A.NAME= B.NAME,A.PASSWORD= B.PASSWORD,A.REALNAME= B.REALNAME,A.AREA_CODE= B.AREA_CODE,A.RECORD_TYPE= B.RECORD_TYPE,A.ID_CARD= B.ID_CARD,A.CELL_NUMBER= B.CELL_NUMBER,A.MAIL= B.MAIL,A.ADDRESS= B.ADDRESS,A.REG_TIME= B.REG_TIME,A.STATUS= B.STATUS,A.LAST_LOG_TIME= B.LAST_LOG_TIME,A.FIRST_PSWD= B.FIRST_PSWD,A.RECORD_WAY= B.RECORD_WAY,A.IS_SAFE_CHECK= B.IS_SAFE_CHECK,A.VERIFY= B.VERIFY,A.VERIFY_TIME= B.VERIFY_TIME,A.SEND_NUMBER= B.SEND_NUMBER,A.IMPORT_TYPE= B.IMPORT_TYPE,A.REG_IP= B.REG_IP,A.SESSION_ID= B.SESSION_ID,A.ON_LINE= B.ON_LINE,A.ID_TYPE= B.ID_TYPE,A.WEB_NAME= B.WEB_NAME,A.WEB_ADDR= B.WEB_ADDR,A.FIRST_LAND_TIME= B.FIRST_LAND_TIME,A.ISP_CODE= B.ISP_CODE,A.IS_ABLE= B.IS_ABLE,A.LINK_STATE= B.LINK_STATE,A.PASSWD= B.PASSWD,A.OPEN_ID= B.OPEN_ID,A.OPEN_IDS= B.OPEN_IDS,A.CREAT_TIME= B.CREAT_TIME,A.UPDATE_TIME= B.UPDATE_TIME,A.UNIQUE_KEY= B.UNIQUE_KEY,A.TYPE= B.TYPE,A.TYPE_BASE= B.TYPE_BASE,A.WIRELESSNET_STATE= B.WIRELESSNET_STATE,A.CHANNEL_ID= B.CHANNEL_ID,A.CREATE_TIME= B.CREATE_TIME; MERGE INTO TRAID_PERSON A USING TRAID_PERSON_UP B ON (A.ID = B.ID) WHEN MATCHED THEN UPDATE SET A.DEPT_NAME= B.DEPT_NAME,A.NAME= B.NAME,A.DUTY= B.DUTY,A.PHONE= B.PHONE,A.USERID= B.USERID,A.TYPE_BASE= B.TYPE_BASE,A.DEPTID= B.DEPTID,A.SON_USER_ID= B.SON_USER_ID,A.CREATE_TIME= B.CREATE_TIME,A.UPDATE_T