Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-30354: Query rewrite not allowed on SYS relations



ORA-30354: Query rewrite not allowed on SYS relations..

Answer / guest

Cause: A SYS relation was referenced in the select clause
for a materialized view with query rewrite enabled.

Action: Remove the reference to the SYS relation from the
select clause 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

RMAN-06001: error parsing job step library

1 Answers  


ORA-39093: FLASHBACK automatically enabled to preserve database integrity.

1 Answers  


ORA-15113: alias name 'string' refers to a directory

1 Answers  


ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

1 Answers  


NNL-00981: Timeouts, server not responding: number

1 Answers  






ORA-14626: values being added already exist in DEFAULT subpartition

1 Answers  


ORA-31475: redo log catalog contains no metadata for the source table

1 Answers  


RMAN-08523: restoring datafile string to string

1 Answers  


ORA-10641: Cannot find a rollback segment to bind to

1 Answers  


ORA-06134: NETTCP: file access privilege violation

1 Answers  


ORA-01562: failed to extend rollback segment number string

1 Answers  


ORA-37016: (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.

1 Answers  






Categories