materialized view for for a duration with fast refresh such as last ten minutes <p>12015 while creating MV in my 3rd step:</p> <ol> <li><p>create table tab_2 as select * from tab_1; alter table tab_2 add constraint tab_2_pk primary key (col6,col7);</p></li> <li><p>create materialized view log on my_schema.tab_2 with primary key (my_date) including new values;</p></li> <li><p>create materialized view my_schema.ten_minute_data refresh fast as select * from my_schema.tab_2 mt where mt.my_date > sysdate-10/(24*60);</p></li> </ol> <p>I am trying to create mv and mv_log in the same db as replacement of normal view to query and see the the result fast.</p> <p>Please suggest if it such where clause is possible.</p> <p>Thanks</p>