我使用以下代码创建了一个Materialized视图:
CREATE MATERIALIZED VIEW M_USER_HIERARCHY BUILD IMMEDIATE REFRESH COMPLETE START WITH TO_DATE('25-Aug-2009 10:34:24','dd-mon-yyyy hh24:mi:ss') NEXT SYSDATE + 1 WITH PRIMARY KEY AS SELECT * FROM V_USER_HIERARCHY;
但是,我希望能够在执行此代码后更改START WITH日期.
我一直在查看ALL_MVIEW_ *表,但找不到START_DATE的设置.
有谁知道如何更改物化视图的START_WITH日期?