Sheduling Materialzed View (Oracle 8i)
Posted on 2004-09-06
I created thre Materialized view and I want to auto recreate it every two hours....
Here is my sql cmd :
Alter materialized view mv_artikel_desc
start with sysdate
next sysdate + 2/ 24;
After that The compile flag of this materialized view is Needs_compile...
It seems that it doesn't recreate the view every two hours....