Oracle Error ORA-30354: Query rewrite not allowed on SYS relations

Oracle Error Message

ORA-30354: Query rewrite not allowed on SYS relations

Reason for the Error

A SYS relation was referenced in the select clause for a materialized view with query rewrite enabled.

Solution

Remove the reference to the SYS relation from the select clause or disable the REWRITE option on the materialized view.