修改物化视图查询 [英] Modify materialized view query

问题描述

我需要修改实例化视图查询.无需删除并重新创建它即可执行相同操作.

I need to modify Materialized view query . Is is possible to do the same without droping and recreating it.

推荐答案

不，您不能不删除实例化视图而对其进行查询.

No, you cannot alter the query of a materialized view without dropping it.

CREATE MATERIALIZED VIEW语法不支持该功能.

The CREATE MATERIALIZED VIEW syntax does not support that feature.

ALTER MATERIALIZED VIEW用于通过以下一种或多种方式修改现有的物化视图:

The ALTER MATERIALIZED VIEW is used to modify an existing materialized view in one or more of the following ways:

• 更改其存储特征
• 更改其刷新方法，模式或时间
• 更改其结构，使其成为不同类型的实例化视图
• 启用或禁用查询重写

有关以下信息，请参见Oracle 12c第1版手册:

See Oracle 12c Release 1 Manual for:

• 创建材料视图语法: http://docs.oracle.com/cd/E16655_01 /server.121/e17209/statements_6002.htm#i2145767

• CREATE MATERIALIZED VIEW syntax: http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_6002.htm#i2145767

ALTER MATERIALIZED VIEW语法: http://docs.oracle.com/cd/E16655_01 /server.121/e17209/statements_2002.htm#SQLRF00808

ALTER MATERIALIZED VIEW syntax: http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_2002.htm#SQLRF00808

这篇关于修改物化视图查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！