This discussion is archived
4 Replies Latest reply: Nov 3, 2013 11:57 PM by Jonathan Lewis RSS

Create materialized view

b8021c1f-1151-49e7-aae2-7ff53df48e85 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points