Rem *** START TUNE_MVIEW section 10g

VARIABLE name_01 varchar2(30)

EXECUTE DBMS_ADVISOR.TUNE_MVIEW     -
( :name_01                          -
, 'CREATE MATERIALIZED VIEW prod_mv -
   REFRESH FAST WITH ROWID          -
   ENABLE QUERY REWRITE             -
   AS                               -
   SELECT DISTINCT                  -
          prod_name, prod_category  -
   FROM   products'                 -
) ;
