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-27025: skgfqsbi: invalid media manager context area size

1 Answers  


IMG-00814: fail queue free failed

1 Answers  


QSM-00777: the specified directive string is unsupported at this time

1 Answers  


RMAN-08585: copying standby controlfile

1 Answers  


NZE-29032: The given identity is not complete.

1 Answers  






ORA-08261: ora_addr: cannot find name in nameserver

1 Answers  


ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.

1 Answers  


ORA-23602: Invalid streams process type string

1 Answers  


ORA-07449: sc: usnewlock failed.

1 Answers  


ORA-29914: ODCIGETINTERFACES routine does not return required stream version

1 Answers  


ORA-07281: slsget: times error, unable to get cpu time.

1 Answers  


NPL-00411: incoming ASN.1 NULL encoding has nonzero length of string

1 Answers  


Categories