存储过程带alter的解决方案

BEGIN
execute immediate
'alter materialized view dblink.TEST_MV_COPY
refresh force on demand
start with sysdate next
sysdate + 5/1440
';
--commit;
end;

posted @ 2020-08-06 10:53  覃上  阅读(473)  评论(0编辑  收藏  举报