物化视图刷新-落地表-调度过程

最新推荐文章于 2025-09-04 02:37:55 发布

原创

最新推荐文章于 2025-09-04 02:37:55 发布 · 534 阅读

3 ·

CC 4.0 BY-SA版权

--1.create materialized view log on YWUSER.BIAUTOPRICEXOM with primary key; --在dblink远程表创建log

--1.在ods用户下创建表，删表空间，主键，添加lastmodifydate 默认系统时间，注释
create table BIAUTOPRICEXOM
(
autopricedemandno VARCHAR2(100) not null,
certino VARCHAR2(100),
riskcode VARCHAR2(4),
autopriceflag VARCHAR2(1),
autopricereason VARCHAR2(1000),
filedexp NUMBER(4,2),
targetlr NUMBER(8,4),
feerate NUMBER(8,4),
managementfeerate NUMBER(8,4),
profitrate NUMBER(8,4),
ccimrk VARCHAR2(1),
accidentrecordsr VARCHAR2(5),
accidentrecordsb VARCHAR2(5),
endorsementrater NUMBER(8,4),
endorsementrateb NUMBER(8,4),
premiumpercent NUMBER(8,4),
govdiscfloor NUMBER(10,6),
govdisctop NUMBER(10,6),
expdisc NUMBER(10,6),
customerno VARCHAR2(50),
uwdisc NUMBER(10,6),
comcostprem NUMBER(