oracle - SQL 错误 : ORA-32361

Question

当我在 Oracle Database 12c 第 2 版中创建实时物化 View 时，出现 SQL 错误:ORA-32361。这是什么意思？

我的观点很简单，没有任何聚合。

CREATE MATERIALIZED VIEW example_t_mv
REFRESH FAST ON DEMAND
ENABLE QUERY REWRITE
ENABLE ON QUERY COMPUTATION
AS
SELECT et.some_value_1, et.some_value_2                         
FROM   example_t et WHERE et.some_value_2 < 10;

SQL Error: ORA-32361: cannot ENABLE ON QUERY COMPUTATION for the materialized view

Answer 1

创建MVLog并尝试创建MV

CREATE MATERIALIZED VIEW LOG ON example_t
WITH ROWID, SEQUENCE(some_value_1, some_value_2)
INCLUDING NEW VALUES;