3

When I create real-Time Materialized Views in Oracle Database 12c Release 2 I get SQL Error: ORA-32361. What does it mean?

My view is simple, without any aggregation.

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

Kaushik Nayak
  • 30,772
  • 5
  • 32
  • 45
Marek A
  • 31
  • 4
  • 1
    Please post entire error message – Lukasz Szozda Mar 23 '18 at 14:59
  • 1
    Interesting. I got the same error in 12c R2 when I ran some other create mv statement with `ENABLE ON QUERY COMPUTATION` after creating mv logs and there aren't any lines further after this error message. – Kaushik Nayak Mar 23 '18 at 15:17

1 Answers1

0

Create MVLog and try to create the MV

CREATE MATERIALIZED VIEW LOG ON example_t
WITH ROWID, SEQUENCE(some_value_1, some_value_2)
INCLUDING NEW VALUES;
Yahya Hussein
  • 8,767
  • 15
  • 58
  • 114
Batu
  • 1
  • 1