** Trace output from the MV group refresh

SQL> /*
DOC>When an MV is in a refresh group, to ensure rollback capability,
DOC>'delete' is used to 'complete' refresh the MV, instead of truncate.
DOC>
DOC>*/
SQL> 
SQL> 
SQL> create materialized view test2_mv nologging
  2  as select * from test2;

Materialized view created.

SQL> 
SQL> create materialized view dual_mv
  2  as select * from dual;

Materialized view created.

SQL> 
SQL> begin
  2  dbms_refresh.make(
  3  name => 'mv_grp1',
  4  list => 'test2_mv,dual_mv',
  5  next_date => sysdate,
  6  interval  =>'sysdate+1/24',
  7  implicit_destroy =>true);
  8  end;
  9  /

PL/SQL procedure successfully completed.

SQL> 
SQL> select object_type from user_objects where object_name='MV_GRP1';

no rows selected

SQL> 
SQL> alter session set sql_trace=true;

Session altered.

SQL> execute dbms_refresh.refresh('mv_grp1');

PL/SQL procedure successfully completed.

SQL> alter session set sql_trace=false;

Session altered.

SQL> 
SQL> execute dbms_refresh.destroy('mv_grp1');

PL/SQL procedure successfully completed.

SQL> drop materialized view test2_mv;

Materialized view dropped.

SQL> drop materialized view dual_mv;

Materialized view dropped.

SQL> 
SQL> 
SQL> spool off