ORA-30353: expression not supported for query rewrite
Answer / guest
Cause: 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, etc.
Action: Remove the offending expression or disable the
REWRITE option on the materialized view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-24321: inconsistent parameters passed
QSM-00510: statistics missing on materialized views
ORA-22885: cannot get REF to a non-persistent object
UDE-00051: unable to set NLS_NUMERIC_CHARACTERS to required defaults.
NID-00127: All online files in the database must have the same checkpoint SCN
ORA-23291: Only base table columns may be renamed
CLSR-00001: Oracle error number encountered
PLS-01906: : raw variable length too long
ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
PCC-02209: Macro invocation has incorrect number of arguments
DRG-50600: assertion failed
QSM-02006: subquery in FROM list