1.创建物化视图
create materialized view MV_TEST
refresh force on demand
start with to_date('20-07-2018 05:30:00', 'dd-mm-yyyy hh24:mi:ss') next TO_DATE(CONCAT(TO_CHAR( SYSDATE+1,'DD-MM-YYYY'),'05:30:00'),'DD-MM-YYYY HH24:MI:SS')
as
select a.id,
a.id,
a.name,
a.type
from gsc.approve a ;
2.刷新物化视图的存储过程
CREATE OR REPLACE PROCEDURE REFRESH_MV_TEST_PROC
AS
BEGIN
dbms_refresh.refresh('"GSC"."MV_TEST"');
END;