QSM-02079 materialized view log must have ROWID
Description:
QSM-02079 materialized view log must have ROWID
Cause:
The capability in question is not supported when the relevant materialized view log omits ROWIDs.
Error List
Error List for the ‘Oracle’ Category
QSM-02080 materialized view log must have primary key
Description:
QSM-02080 materialized view log must have primary key
Cause:
The capability in question is not supported when the relevant materialized view log omits primary keys.
QSM-02081 materialized view log does not have all necessary columns
Description:
QSM-02081 materialized view log does not have all necessary columns
Cause:
The capability in question is not supported when the relevant materialized view log omits columns referenced in the select list of the materialized view.
QSM-02082 problem with materialized view log
Description:
QSM-02082 problem with materialized view log
Cause:
The capability in question is not supported because of a problem with the materialized view log.
QSM-02083 materialized view references PL/SQL function that maintains state
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.
QSM-02084 DISTINCT clause on a duplicate sensitive aggregate function
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.
QSM-02086 materialized view uses the MIN or MAX aggregate functions
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.
QSM-02088 materialized view omits at least one grouping key from the select list
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.
QSM-02090 SELECT includes an expression that is not just a column
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.
QSM-02091 materialized view references a non-repeatable or session-sensitive expression
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.