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-01053: NORELY referential integrity constraint on table, string, in TRUSTED/STALE TOLERATED integrity mode

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-02027: group by ROLLUP

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