gpt4 book ai didi

oracle10g - TOAD-修改物化 View 选择查询而不丢弃

转载 作者:行者123 更新时间:2023-12-04 05:12:03 25 4
gpt4 key购买 nike

有什么方法可以编辑 MVIEW 查询而不将其放入 TOAD。我不确定我们是否可以做到?如果不能,我该如何以不影响表格内容的方式进行?

提前致谢

最佳答案

您无法更改物化 View 查询,您必须删除并重新创建它。

见:http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_2001.htm

Use the ALTER MATERIALIZED VIEW statement to modify an existing materialized view in one or more of the following ways:

  • To change its storage characteristics

  • To change its refresh method, mode, or time

  • To alter its structure so that it is a different type of materialized view

  • To enable or disable query rewrite

关于oracle10g - TOAD-修改物化 View 选择查询而不丢弃,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/14801287/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com