ORA-30353: expression not supported for query rewrite Cause: The SELECT clausereferenced UID, USER, ROWNUM, SYSDATE,
CURRENT_TIMESTAMP, MAXVALUE, a sequence number, a bind variable,
correlation variable, a set result, a trigger return variable, a parallel tablequeue
column, collection iterator, a non-deterministic date format token RR, etc. Action: Remove the offendingexpression or disable the REWRITE option on the
materialized view.