ORACLE：物化视图 – 变动START WITH CLAUSE

我行使以下代码建设了一个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日期？

办理要领

SQL> create materialized view emp_data
  2  as select * from emp
  3  /

Materialized view created.

SQL> ALTER MATERIALIZED VIEW emp_data
  2     REFRESH COMPLETE
  3     START WITH TRUNC(SYSDATE+1) + 12/24
  4     NEXT SYSDATE+1
  5  /

Materialized view altered.

SQL>

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!