Oracle Error Message
ORA-30353: expression not supported for query rewrite
Reason for the Error
The SELECT clause referenced UID, USER, ROWNUM, SYSDATE, CURRENT_TIMESTAMP, MAXVALUE, a sequence number, a bind variable, correlation variable, a set result, a trigger return variable, a parallel table queue column, collection iterator, a non-deterministic date format token RR, etc.
Solution
Remove the offending expression or disable the REWRITE option on the materialized view.
