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 |
DRG-50701: error in listener.get_cmd()
ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified
ORA-02039: bind by value is not allowed for array type
ORA-23376: node string is not compatible with replication version "string"
RMAN-06463: Backup set key string cannot be backed up by proxy.
ORA-02715: osnpgetbrkmsg: message from host had incorrect message type
PLS-00580: supertype must be an object type
ORA-16785: The database is not in ARCHIVELOG mode
PLS-00644: character set mismatch found at 'string' among result expressions in a CASE expression
ORA-03235: max # extents (string) reached in table string.string subpartition string
ORA-36400: (XSSPROP02) workspace object is not a valid variable name.
ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.