Database Error Messages

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

QSM-01353

no query rewrite on remote objects unless integrity mode is set to stale_tolerated

Cause

Query rewrite's integrity mode should be set to stale_tolerated for query rewrite to occur on queries with remote objects


Action

Set the session parameter, QUERY_REWRITE_INTEGRITY to stale_tolerated