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-23373: object group "string"."string" does not exist

1 Answers  


TNS-12662: proxy ticket retrieval failed

1 Answers  


ORA-16150: FINISH recovery performed on another, older standby database

1 Answers  


ORA-26688: missing key in LCR

1 Answers  


ORA-09208: sftcls: error closing file

1 Answers  






ORA-23535: instantiating templates from multiple back ends is not allowed.

1 Answers  


ORA-02447: cannot defer a constraint that is not deferrable

1 Answers  


ORA-07841: sllfop: SYS$OPEN failure

1 Answers  


ORA-00331: log version string incompatible with ORACLE version string

2 Answers  


RMAN-10033: error during compilation of job step number: string

1 Answers  


ORA-02449: unique/primary keys in table referenced by foreign keys

1 Answers  


RMAN-00600: internal error, arguments [string] [string] [string] [string] [string]

1 Answers  


Categories