Errores QSM
Errores QSM mas frecuentes
QSM-02068: relation is not a partitioned table
QSM-01085: materialized view, string, has a lossy join between tables, string
QSM-02050: subquery using the ALL clause in materialized view
QSM-02072: requirements not satisfied for fast refresh of nested materialized view
QSM-01069: summary join graph for, string, does not have table, string
QSM-02002: DISTINCT aggregate measure in SELECT list
QSM-02019: materialized view references another materialized view in FROM clause
QSM-02062: GROUP BY clause in materialized view
QSM-01055: Query Rewrite failed to allocate the necessary materialized view join graph
QSM-02179: MV with UNION ALL requires compatibility >= 9.2.0
QSM-01050: roll-up check failed for materialized view, string
QSM-02055: materialized view references a packed object table or view
QSM-02129: join or filter conditions are complex
QSM-02114: no GROUP BY clause, no aggregates, and not >= 9.0 compatibility
QSM-02123: subquery and UNION materialized views must be primary key materialized views
QSM-02029: PL/SQL function invocation
QSM-02056: correlated variable and outer join in materialized view
QSM-02178: MV has a view with UNION ALL that is not fast refreshable
QSM-01084: materialized view, string, has anchor, string, not found in query
QSM-02013: SELECT list includes a RAW data type expression
QSM-02071: internal error: undefined PCT failure code
QSM-02131: agg(expr) requires corresponding SUM(expr) function
QSM-02136: agg(expr) requires corresponding VARIANCE(expr) function
QSM-02141: the reason why the capability is disabled has escaped analysis
QSM-02004: grouping column omitted from SELECT list
QSM-01104: query is using flashback
QSM-02035: no filter conditions are present in the HAVING clause
QSM-02086: materialized view uses the MIN or MAX aggregate functions
QSM-02040: top level query contains GSets and the key is too long for rewrite
QSM-02070: PCT not supported with this type of partitioning
QSM-02096: materialized view references a named view
QSM-02088: materialized view omits at least one grouping key from the select list
QSM-02139: agg(expr) requires corresponding agg(expr+expr) function
QSM-01064: query has a fixed table or view
QSM-02017: subquery present in the HAVING clause
QSM-02036: in-list present in materialized view
QSM-02101: materialized view references a synonym in the FROM list
QSM-02134: agg(expr) requires corresponding MAX(expr) function
QSM-02140: agg(expr) requires corresponding SUM(expr*expr) function
QSM-02125: subquery join conditions don't meet requirements for capability
QSM-02132: agg(expr) requires corresponding COUNT(expr) function
QSM-02121: set operator in a context not supported for fast refresh
QSM-01043: join back attempted on a table to the RHS of a semi or anti join for string
QSM-02006: subquery in FROM list
QSM-02118: duplicate grouping sets
QSM-02150: select lists must be identical across the UNION operator
QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function
QSM-02138: agg(expr) requires corresponding agg(expr*expr) function