lingesh

• Oct 5th, 2006

 

Yaa we can refresh materialized view. While creating of materialized views we can give options such as refresh fast and we can mention time so that it can refresh automatically and fetch new data i..e updateed data and inserted data. For active dataware house i mean inorder to have real time dataware house we can have materialized views.

   EX:- see this

                 CREATE MATERIALIZED VIEW mv_emp_pk
   REFRESH FAST START WITH SYSDATE
  NEXT  SYSDATE + 1/48
  WITH PRIMARY KEY
                AS SELECT * FROM emp@remote_db;