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-01150: cannot prevent writes - file string has online backup set
RMAN-03029: echo set on
ORA-28038: disallow O2LOGON
ORA-19648: datafile string: incremental-start SCN equals checkpoint SCN
ORA-32032: free temporary object number not available
TNS-12609: TNS: Receive timeout occurred
PCB-00552: The SQLCA and a SQLCODE variable cannot both be used
ORA-09913: Malloc of dummy name failed.
PCC-01300: You are not authorized to run Pro*PL/I
ORA-19028: Invalid ADT parameter passed to toObject() function
ORA-13240: specified dimensionality greater than that of the query mbr
ORA-09802: Conversion of binary label to string failed.