I'm writing a Mview for a summary table and I'm not sure if the options I chose is right. I created a log file on tab
CREATE MATERIALIZED VIEW LOG ON tab;
And then a mview on tab as below:
create materialized view mv_sumtab
enable query rewrite
START WITH SYSDATE NEXT trunc(SYSDATE) + 1
select DISTINCT a.UNIT
from tab a
I get this error:
ERROR at line 3:
ORA-00905: missing keyword
I'm not clear about "enable query rewrite" too. I read some stuff online but unable to comprehend. Can someone please explain in brief about it?
Thanks in advance.