4 Replies Latest reply: Nov 4, 2013 1:57 AM by Jonathan Lewis RSS

    Create materialized view

    b8021c1f-1151-49e7-aae2-7ff53df48e85

      Hi

      How can i create MV with following attribute:

      sample:

      CREATE MATERIALIZED VIEW log on test_m  WITH ROWID;

      CREATE MATERIALIZED VIEW MV_test

         REFRESH fast on commit   WITH ROWID

      for update

      as SELECT

      id,

      name,

      TO_CHAR ('0') as status

      FROM test_m;

       

      But i got this error:

      SQL Error: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view