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

ORA-23400: invalid materialized view name "string"

1 Answers  


ORA-13702: Snapshot IDs specified by the range [string, string] are equal.

1 Answers  


ORA-24395: cannot reinitialize non-existent pool

1 Answers  


ORA-09318: slkhst: unable to host out to operating system

1 Answers  


QSM-02120: compatibility mode must be 9.0 or higher

1 Answers  


ORA-00334: archived log: 'string'

1 Answers  


ORA-37007: (AWLISTALL05) number writer

1 Answers  


ORA-02304: invalid object identifier literal

1 Answers  


ORA-36198: (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified %4p as a weight.

1 Answers  


PLS-00381: type mismatch found at 'string' between column and variable in subquery or INSERT

1 Answers  


SQL*Loader-00944: error preparing insert statement for table string.

1 Answers  


LSX-00250: invalid normalizedString "~S"

1 Answers  


Categories