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

EXP-00015: error on row number of table string, column string, datatype number

1 Answers  


NNO-00710: server's cache will be dumped to the trace file in number seconds

1 Answers  


ORA-25147: UNIFORM SIZE value greater than maximum extent size

1 Answers  


ORA-09976: skxfqdini: Error Creating Port

1 Answers  


ORA-14259: table is not partitioned by Hash method

1 Answers  


ORA-01316: Already attached to a Logminer session

1 Answers  


TNS-12597: TNS:connect descriptor already in use

1 Answers  


ORA-06712: TLI Driver: error on accept

1 Answers  


SQL*Loader-00127: Invalid maximum record size

1 Answers  


ORA-38406: attribute set string already exists

1 Answers  


CLSR-00503: Error number encountered when creating an EVM event

1 Answers  


LPX-00109: duplicate name "~S" in mixed-content declaration

1 Answers  


Categories