SQL> CREATE TABLE TBL
  2    AS
  3      SELECT  *
  4        FROM  EMP
  5        WHERE 1 = 2
  6  /

Table created.

Elapsed: 00:00:00.02
SQL> CREATE MATERIALIZED VIEW LOG
  2    ON TBL
  3    WITH ROWID,
  4         COMMIT SCN(
  5                    EMPNO,
  6                    ENAME,
  7                    JOB,
  8                    MGR,
  9                    HIREDATE,
 10                    SAL,
 11                    COMM,
 12                    DEPTNO
 13                   )
 14         INCLUDING NEW VALUES
 15  /

Materialized view log created.

Elapsed: 00:00:00.02
SQL> CREATE MATERIALIZED VIEW TBL_MV
  2    REFRESH FAST
  3    ON DEMAND
  4    WITH ROWID
  5    AS
  6      SELECT  ROWID RID
  7        FROM  TBL
  8        WHERE 1 = 2
  9  /

Materialized view created.

Elapsed: 00:00:00.08
SQL> INSERT
  2    INTO TBL
  3    SELECT  *
  4      FROM  EMP
  5  /

14 rows created.

Elapsed: 00:00:00.02
SQL> COMMIT
  2  /

Commit complete.

Elapsed: 00:00:00.01
SQL> BEGIN
  2      FOR V_REC IN (SELECT * FROM EMP WHERE ROWNUM = 1) LOOP
  3        FOR V_I IN 1..100000 LOOP
  4          INSERT
  5            INTO TBL
  6            VALUES V_REC;
  7          COMMIT;
  8        END LOOP;
  9      END LOOP;
 10  END;
 11  /

PL/SQL procedure successfully completed.

Elapsed: 00:02:10.38
SQL> COMMIT
  2  /

Commit complete.

Elapsed: 00:00:00.01
SQL> SELECT  COUNT(*)
  2    FROM  SYS.SNAP_XCMT$
  3  /

  COUNT(*)
----------
    100001

Elapsed: 00:00:00.02
SQL> EXEC DBMS_MVIEW.REFRESH('TBL_MV')

PL/SQL procedure successfully completed.

Elapsed: 00:00:03.89
SQL> SELECT  COUNT(*)
  2    FROM  SYS.SNAP_XCMT$
  3  /

  COUNT(*)
----------
         0

Elapsed: 00:00:00.01
SQL> 

CREATE MATERIALIZED VIEW TBL_MV
  REFRESH FAST
  ON DEMAND
  WITH ROWID
  AS
    SELECT  ROWID RID
      FROM  TBL
      WHERE 1 = 2
/