存储过程带alter的解决方案
BEGIN
execute immediate
'alter materialized view dblink.TEST_MV_COPY
refresh force on demand
start with sysdate next
sysdate + 5/1440
';
--commit;
end;
BEGIN
execute immediate
'alter materialized view dblink.TEST_MV_COPY
refresh force on demand
start with sysdate next
sysdate + 5/1440
';
--commit;
end;