Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

QSM-01030

materialized view, string, has PL/SQL functions in ENFORCED integrity mode

Cause

A materialized view with PL/SQL functions in its definition cannot be used for query rewrite when query rewrite integrity is set to ENFORCED.


Action

Consider running the query in STALE TOLERATED mode.