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-19677: RMAN configuration name exceeds maximum length of string
PCB-00554: Must include SQLCA when mode=ANSI and WHENEVER SQLWARNING used
QSM-01120: recursive rewrite not allowed here
ORA-06250: NETNTT: cannot allocate send and receive buffers
ORA-30432: summary 'string.string' is in INVALID state
ORA-03241: Invalid unit size
ORA-07512: sscggtl: $enq unexpected return for client termination lock
ORA-13231: failed to create index table [string] during R-tree creation
ORA-28558: HS_FDS_CONNECT_STRING undefined for non-Oracle system
ORA-38449: table "string" does not exist or is not accessible
ORA-06926: CMX: T_ERROR during read data
ORA-09968: scumnt: unable to lock file