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-02330: datatype specification not allowed
LSX-00117: "minLength" should not be greater than "maxLength"
RMAN-06905: backup of backupset key number was cancelled
ORA-29345: can not plug a tablespace into a database using a different character set
SQL-02113: Unable to open message file
ORA-06593: %s is not supported with natively compiled PL/SQL modules
ORA-19025: EXTRACTVALUE returns value of only one node
ORA-00827: could not shrink sga_target to specified value
ORA-32142: maximum number of iterations exceeded
PCC-02389: Arrays not allowed as input bind variables in SELECT list
ORA-16136: Managed Standby Recovery not active
PLS-01505: ALTER is non-ANSI