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

PLS-00540: object not supported in this context.

1 Answers  


ORA-30445: workload queries not found

1 Answers  


ORA-12806: could not get background process to hold enqueue

1 Answers  


ORA-23336: priority group string does not exist

1 Answers  


ORA-28037: Cannot Get Session Key for RACF Authentication

1 Answers  


ORA-13764: Value "string" is illegal as a result percentage.

1 Answers  


CLSS-02202: voting device access took an excessive amount of time. (string sec)

1 Answers  


NZE-28844: No wallet present

1 Answers  


ORA-09243: smsget: error attaching to SGA

1 Answers  


ORA-39024: wrong schema specified for job

1 Answers  


TNS-04002: The command completed successfully.

1 Answers  


ORA-40105: input data incompatible with model signature

1 Answers  


Categories