问题描述
我需要修改实例化视图查询.无需删除并重新创建它即可执行相同操作.
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:
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
这篇关于修改物化视图查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！