Error List

Error List for the ‘ORADB-QSM’ Category

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.

ORADB-QSM

QSM-02134 agg(expr) requires corresponding MAX(expr) function

Description:
QSM-02134 agg(expr) requires corresponding MAX(expr) function

Cause:
The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the MAX function on the same argument.

ORADB-QSM

QSM-02113 expression in select list references multiple tables or views

Description:
QSM-02113 expression in select list references multiple tables or views

Cause:
The capability in question is not supported when the materialized view includes an expression in the select list that references multiple tables or views.

ORADB-QSM

QSM-02145 GROUP BY clause is present but no aggregate functions are used

Description:
QSM-02145 GROUP BY clause is present but no aggregate functions are used

Cause:
A GROUP BY clause is used but no aggregate functions are present in the select list.

ORADB-QSM

QSM-02077 materialized view log is newer than last full refresh

Description:
QSM-02077 materialized view log is newer than last full refresh

Cause:
The capability in question is not supported when the relevant materialized view log was created after the creation or most recent complete refresh of the materialized view.

ORADB-QSM

QSM-02124 object type in WHERE clause

Description:
QSM-02124 object type in WHERE clause

Cause:
The capability in question is not supported when the materialized view references an object type in the WHERE clause.

ORADB-QSM

QSM-02163 cannot use object id columns from materialized view log

Description:
QSM-02163 cannot use object id columns from materialized view log

Cause:
The materialized view log either does not have object id columns logged, or the timestamp associated with the object id columns is more recent than the last refresh time.

ORADB-QSM

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.

ORADB-QSM

QSM-02135 agg(expr) requires corresponding AVG(expr) function

Description:
QSM-02135 agg(expr) requires corresponding AVG(expr) function

Cause:
The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the AVG function on the same argument.

ORADB-QSM

QSM-02114 no GROUP BY clause, no aggregates, and not >= 9.0 compatibility

Description:
QSM-02114 no GROUP BY clause, no aggregates, and not >= 9.0 compatibility

Cause:
The capability in question is not supported when the materialized view has no GROUP BY clause, no aggregates, and compatibility mode is less than 9.0.

ORADB-QSM