4 Replies Latest reply on Jul 1, 2009 11:36 AM by oracle.beginner

    creation of materialized view with view log file for fast refresh in 10.1db

      Hi,.. I have a select statements that includes data from almost 20 tables and takes long time to complete..I am planing to create a materialized view on this.. would you please suggest best way of doing this?
      we would like to have materialized view and materialized log file to refresh changes from underline table to mv view. please provide help on this .. thanks in advance