ORA-30353: expression not supported for query rewrite



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

Post New Answer

More Oracle Errors Interview Questions

ORA-02330: datatype specification not allowed

1 Answers  


LSX-00117: "minLength" should not be greater than "maxLength"

1 Answers  


RMAN-06905: backup of backupset key number was cancelled

1 Answers  


ORA-29345: can not plug a tablespace into a database using a different character set

1 Answers  


SQL-02113: Unable to open message file

1 Answers  






ORA-06593: %s is not supported with natively compiled PL/SQL modules

1 Answers  


ORA-19025: EXTRACTVALUE returns value of only one node

1 Answers  


ORA-00827: could not shrink sga_target to specified value

1 Answers  


ORA-32142: maximum number of iterations exceeded

1 Answers  


PCC-02389: Arrays not allowed as input bind variables in SELECT list

1 Answers  


ORA-16136: Managed Standby Recovery not active

2 Answers  


PLS-01505: ALTER is non-ANSI

1 Answers  


Categories