I need your help with a issue on Oracle Materialized View.
I created the Materialized View using the following command:
CREATE MATERIALIZED VIEW SNAP_TEST TABLESPACE tbs NOCACHE LOGGING NOPARALLEL REFRESH COMPLETE START WITH TO_DATE('10-nov-2011 07:00:00','dd-mon-yyyy hh24:mi:ss') NEXT SYSDATE+1 AS SELECT item from item@abc;
If I manually refresh it everything works properly. But it doesn't work automatically: I expected an auto-refresh everyday at 7:00, but it never happened. Why? Do I have to activate something?