Errores QSM
Errores QSM mas frecuentes
QSM-02142: COUNT(*) is not present in the select list
QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function
QSM-02086: materialized view uses the MIN or MAX aggregate functions
QSM-02150: select lists must be identical across the UNION operator
QSM-01047: complex join back on non-MAV rewrite not allowed (string)
QSM-02073: non-primary key RepAPI materialized view is not fast refreshable
QSM-02106: materialized view uses a filter condition in the WHERE or HAVING clause
QSM-02077: materialized view log is newer than last full refresh
QSM-02143: SUM(expr) without COUNT(expr)
QSM-02042: view or subquery in from list
QSM-02121: set operator in a context not supported for fast refresh
QSM-02033: no filter conditions are present in the WHERE clause
QSM-01058: materialized view, string, does not have column, string, for a joinback
QSM-02112: top level query has LEFT OUTER, RIGHT OUTER, or FULL OUTER join
QSM-02001: clustered materialized view container table
QSM-02126: no rowid at master site
QSM-01044: join back attempted on a view for string
QSM-02104: aggregate function in a filter condition in the HAVING clause
QSM-01083: query text not available - possible inline view
QSM-02034: no joins are present in the HAVING clause
QSM-02063: aggregate function in materialized view
QSM-01046: complex join back on correlated columns not allowed (string)
QSM-02014: GROUP BY expression other than a column
QSM-01096: Materialized view with grouping sets contains duplicates
QSM-01048: join back level(s) not present (string)
QSM-02079: materialized view log must have ROWID
QSM-02080: materialized view log must have primary key
QSM-02135: agg(expr) requires corresponding AVG(expr) function
QSM-02039: top level materialized view query uses grouping sets
QSM-02007: multiple instances of the same table or view
QSM-01100: containment check failed for mv, string
QSM-02016: clustered table in FROM list
QSM-02151: subquery or named view in FROM list and < 9.0 compatibility
QSM-02045: START WITH clause in materialized view
QSM-02145: GROUP BY clause is present but no aggregate functions are used
QSM-01065: materialized view, string, cannot compute measure, string, in the query
QSM-01059: HAVING clause in the query block is malformed
QSM-02032: no joins are present in the WHERE clause
QSM-01097: Materialized view with grouping sets has too long key
QSM-01074: materialized view, string, and query have different no of joins between tables, string
QSM-01051: no support for rollup when a window function is present on the column
QSM-02122: compatibility mode must be 8.1 or higher
QSM-01057: no query rewrite for this DML expression
QSM-02119: internal error while analyzing required supporting aggregates
QSM-02148: many to many subquery joins require 9.0 compatibility or higher