Why is my materialized gaze disrupted?

Question

I created a materialized view:

CREATE MATERIALIZED VIEW "SUPUSERWH"."EXAM_MVIEW" ("CODE","AGE")
As    
(
      select CODE, AGE from  EXAM_TEST
)

It worked. Then I inserted one row into the table EXAM_TESTand updated my connection. Then the materialized view EXAM_MVIEWbroke. Why?

Answer 1

I don’t know what you mean by a broken word, but as you define a materialized view, Oracle would consider it obsolete after pasting in EXAM_TEST.
Stale means that using a materialized view will give a different result than using a base table.

You can fix this:

• Manually refresh the view. This is useful when data is recorded periodically (downloaded once per hour).
• . , , , , , .
• ( query_rewrite_integrity STALE_TOLERATED). . , .

.

Answer 2

DDL (DROP, ALTER...) . , exam_test mv?