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

DRG-10308: no server with the required string personality mask is running

1 Answers  


ORA-00361: cannot remove last log member string for group string

1 Answers  


ORA-01595: error freeing extent (string) of rollback segment (string))

1 Answers  


ORA-01539: tablespace 'string' is not online

1 Answers  


ORA-19682: file string not in block media recovery context

1 Answers  






CLSS-00103: unable to read configuration information for node string

1 Answers  


PLS-00219: label 'string' reference is out of scope

1 Answers  


ORA-12462: undefined compartment string for policy string

1 Answers  


ORA-39087: directory name string is invalid

2 Answers  


RMAN-06176: no recovery required; all files are readonly or offline

1 Answers  


RMAN-06220: Creating automatic instance

1 Answers  


ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]

1 Answers  


Categories