CREATE materialized view mv_LoginUsertest1
refresh fast start with sysdate next sysdate + 1/1440
for update
refresh fast start with sysdate next sysdate + 1/1440
for update
as select * from LoginUser@UserMdb;
CREATE OR REPLACE materialized view mv_LoginUser
refresh fast start with sysdate next sysdate + 1/1440
ENABLE QUERY REWRITE
as select * from LoginUser@UserMdb;