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-12603: CTXSYS does not own user datastore procedure: string
ORA-25441: duplicate column value for table alias: string
DRG-50931: parser not opened
TNS-00512: Address already in use
SQL*Loader-00305: More than one end of file character encountered
RMAN-10028: network error number-number occurred during remote RPC
ORA-23375: feature is incompatible with database version at string
ORA-31109: Action failed as parent resource string is locked
NID-00002: Parse error: string
ORA-36735: A value exceeded the MAX specification
DRG-13312: user CTXSYS does not own USER_LEXER stored procedure string
ORA-24045: invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]