Oracle - creating a Materialized View
I'm reading some articles, even some answers here on stack, but i still have some issues. I'll post my MV code for possible analysis:

    CREATE MATERIALIZED VIEW some_materialized_view
    REFRESH COMPLETE
    START WITH sysdate
    NEXT '2011-12-01' + 31
    WIDTH PRIMARY KEY
    AS my_query

This code is not working for me, am i forgeting something? The only thing i want is that my MV update every month beggining. Can someone help?

Thanks!
Oracle - creating a Materialized View
===

I'm reading some articles, even some answers here on stack, but i still have some issues. I'll post my MV code for possible analysis:

    CREATE MATERIALIZED VIEW some_materialized_view
    REFRESH COMPLETE
    START WITH sysdate
    NEXT '2011-12-01' + 31
    WIDTH PRIMARY KEY
    AS my_query

This code is not working for me, am i forgeting something? The only thing i want is that my MV update every month beggining. Can someone help?

Thanks!