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

SQL*Loader-00509: System error: string

1 Answers  


ORA-23483: object "string"."string" not allowed in this operation.

1 Answers  


O2I-00119: Warning reported by subsystem:

1 Answers  


ORA-00325: archived log for thread string, wrong thread # string in header

1 Answers  


DRG-10309: not enough job queue processes

1 Answers  


ORA-14193: invalid ALTER INDEX MODIFY SUBPARTITION option

1 Answers  


ORA-00398: abort thread recovery due to reconfiguration

1 Answers  


ORA-08319: sllfsk: Error reading file

1 Answers  


ORA-25132: UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION

1 Answers  


TNS-00009: INTCTL: could not contact destination Connection Manager

1 Answers  


ORA-09313: slsprom: error prompting user

1 Answers  


ORA-14634: Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table

1 Answers  


Categories