Description:
QSM-02083 materialized view references PL/SQL function that maintains state
Cause:
The capability in question is not supported when the materialized view references a PL/SQL function that maintains state and which may not return the same value every time it is invoked against the same set of rows.
Description:
QSM-02084 DISTINCT clause on a duplicate sensitive aggregate function
Cause:
The capability in question is not supported when the materialized view uses the DISTINCT clause in this context.
Description:
QSM-02086 materialized view uses the MIN or MAX aggregate functions
Cause:
The capability in question is not supported when the materialized view uses the MIN or MAX function.
Description:
QSM-02088 materialized view omits at least one grouping key from the select list
Cause:
The capability in question is not supported when the materialized view omits any grouping expressions from the select list.
Description:
QSM-02090 SELECT includes an expression that is not just a column
Cause:
The capability in question is not supported when the materialized view uses an expression in the select list that is not a simple column reference.
Description:
QSM-02091 materialized view references a non-repeatable or session-sensitive expression
Cause:
The capability in question is not supported when the materialized view uses an expression that may not return the same value each time it is invoked against the same set of rows or that may return different values depending on session parameters.
Description:
QSM-02092 materialized view references a sequence number
Cause:
The capability in question is not supported when the materialized view references a sequence number.
Description:
QSM-02093 materialized view uses an object REF clause
Cause:
The capability in question is not supported when the materialized view uses an object REF clause.
Description:
QSM-02096 materialized view references a named view
Cause:
The capability in question is not supported when the materialized view references a view.
Description:
QSM-02099 materialized view references a remote table or view in the FROM list
Cause:
The capability in question is not supported when the materialized view references a remote table or view in the FROM list.