对一个实体化视图重建。

最新推荐文章于 2021-08-10 16:02:16 发布

henrybai

最新推荐文章于 2021-08-10 16:02:16 发布

阅读量1.4k

点赞数

分类专栏：数据库文章标签： c sql insert delete table date

本文链接：https://blog.csdn.net/henrybai/article/details/1746426

版权

本文详细介绍了如何重建一个Oracle实体化视图，包括使用DBMS_MVIEW.REFRESH进行刷新，查看其DDL定义，以及处理插入、删除操作以保持数据同步。在过程中遇到了唯一约束冲突的问题，并展示了如何解决这个问题。

摘要由CSDN通过智能技术生成

SQL> exec dbms_mview.refresh('T89','F')

PL/SQL procedure successfully completed.

SQL> select dbms_metadata.get_ddl('MATERIALIZED_VIEW','T89','ARADMIN') from dual

CREATE MATERIALIZED VIEW "ARADMIN"."T89"
ON PREBUILT TABLE WITHOUT REDUCED PRECISION
USING INDEX
REFRESH FORCE ON DEMAND START WITH sysdate+0 NEXT TRUNC(SYSDATE + 1) + 2/24
WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE
AS SELECT
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C536870914,
C536870916,
C536870918,
C536870919,
C536870922,
C536870925,
C536870927,
C536870931,
C536870932,
C536870935,
C536870937,
C536870938,
C536870939,
C536870943,
C536870944,
C536870945,
C536870946,
C536870947,
C536870948,
C536870950,
C536870951,
C536870953,
C536870955,
C536870956,
C536870957,
C536870960,
C536870961,
C536870962,
C536870963,
C536870964,
C536870965,
C53687