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


QSM-01030: materialized view, string, has PL/SQL functions
in ENFORCED integrity mode



QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode..

Answer / guest

Cause: A materialized view with PL/SQL functions in its
definition cannot be used for query rewrite when query
rewrite integrity is set to ENFORCED.

Action: Consider running the query in STALE TOLERATED mode.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01302: dictionary build options missing or incorrect

1 Answers  


ORA-27089: unable to release advisory lock

1 Answers  


LSX-00167: defining form of "~S" must occur at the top level

1 Answers  


DRG-11521: encounter error when updating a LONG or LONG RAW column

1 Answers  


ORA-31223: DBMS_LDAP: cannot open more than string LDAP server connections

1 Answers  






ORA-14015: too many partition descriptions

1 Answers  


PLS-00508: The expression in a RETURN statement cannot be a type

1 Answers  


ORA-36954: (XSFCAST24) The cycle number must be between 1 and number. You specified number.

1 Answers  


ORA-01162: block size string in file header does not match configured block sizes

1 Answers  


NNL-00410: Average response time: string

1 Answers  


ORA-22625: OCIAnyData is not well-formed

1 Answers  


NNL-00270: Current default domain is "string"

1 Answers  






Categories