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

TNS-12618: TNS:versions are incompatible

1 Answers  


ORA-24155: rule string.string not in rule set string.string

1 Answers  


KUP-00562: unknown escape sequence

1 Answers  


ORA-07256: sptrap: cannot set up signal handler to catch exceptions.

1 Answers  


ORA-40214: duplicate setting: string

1 Answers  






SQL*Loader-00520: lfimknam failed for file (string)

1 Answers  


ORA-07240: slemrd: seek error.

1 Answers  


ORA-14608: Tablespace was specified for the previous lob segments of column string in template but is not specified for string

1 Answers  


ORA-02773: Invalid maximum client wait time

1 Answers  


ORA-32027: There is no string column with the matching type in string.string.

1 Answers  


ORA-29525: referenced name is too long: 'string'

1 Answers  


LPX-00124: attribute value should be one or more tokens

1 Answers  


Categories