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-15094: attempted to write to file opened in read only mode

1 Answers  


ORA-01630: max # extents (string) reached in temp segment in tablespace string

1 Answers  


TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC

1 Answers  


ORA-14316: table is not partitioned by List method

1 Answers  


NID-00426: Database ID for database string restored to number.

1 Answers  


RMAN-08533: restoring blocks of datafile string

1 Answers  


LCD-00215: parameter files nested too deep [string]

1 Answers  


ORA-13303: failure to retrieve a geometry object from a table

1 Answers  


ORA-24460: Native Net Internal Error

1 Answers  


QSM-02154: MV is not fast refreshable even with view merging

1 Answers  


DRG-11733: more than one translation for the term in the specified language

1 Answers  


PLS-01701: Illegal syntax in ROLLBACK WORK statement

1 Answers  


Categories