Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-30354: Query rewrite not allowed on SYS relations
Oracle® Database Error ORA-30354541/19

ORA-30354: Query rewrite not allowed on SYS relations

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.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle