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

 

--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