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-10640: Operation not permitted during SYSTEM tablespace migration

1 Answers  


LSX-00010: extra element(s) at end of "~S"

1 Answers  


CLSR-00502: Error number encountered when subscribing an EVM event

1 Answers  


NZE-29163: Third party PKI vendor is not supported in FIPS mode.

1 Answers  


ORA-39006: internal error

1 Answers  






AMD-00101: cannot create string "string"; metadata entity already exists

1 Answers  


NZE-29008: Bad DH Param key length

1 Answers  


TNS-00123: Unable to perform a listen on configured ADDRESS(es)

1 Answers  


ORA-17610: file 'string' does not exist and no size specified

1 Answers  


NZE-28763: Invalid parameter type found in configuration file.

1 Answers  


UDI-00052: incorrect Data Pump client for operation: string

1 Answers  


ORA-02248: invalid option for ALTER SESSION

1 Answers  


Categories