Errores QSM
Errores QSM mas frecuentes
QSM-01082: Joining materialized view, string, with table, string, not possible
QSM-01095: no suitable grouping_id found in materialized view with grouping sets
QSM-02055: materialized view references a packed object table or view
QSM-02130: expression not supported for fast refresh
QSM-02072: requirements not satisfied for fast refresh of nested materialized view
QSM-01055: Query Rewrite failed to allocate the necessary materialized view join graph
QSM-01099: non-tolerated reference to stale portion of materialized view for table string
QSM-02003: aggregate function nested within an expression
QSM-02129: join or filter conditions are complex
QSM-02062: GROUP BY clause in materialized view
QSM-01050: roll-up check failed for materialized view, string
QSM-02163: cannot use object id columns from materialized view log
QSM-02056: correlated variable and outer join in materialized view
QSM-02123: subquery and UNION materialized views must be primary key materialized views
QSM-02114: no GROUP BY clause, no aggregates, and not >= 9.0 compatibility
QSM-02029: PL/SQL function invocation
QSM-02002: DISTINCT aggregate measure in SELECT list
QSM-02040: top level query contains GSets and the key is too long for rewrite
QSM-01104: query is using flashback
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-02141: the reason why the capability is disabled has escaped analysis
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-02013: SELECT list includes a RAW data type expression
QSM-02052: subquery using a select list in materialized view
QSM-02017: subquery present in the HAVING clause
QSM-02139: agg(expr) requires corresponding agg(expr+expr) function
QSM-02004: grouping column omitted from SELECT list
QSM-02035: no filter conditions are present in the HAVING clause
QSM-01103: there is a remote table, string, referenced in the query
QSM-02101: materialized view references a synonym in the FROM list
QSM-02134: agg(expr) requires corresponding MAX(expr) function
QSM-01064: query has a fixed table or view
QSM-02096: materialized view references a named view
QSM-01043: join back attempted on a table to the RHS of a semi or anti join for string
QSM-02088: materialized view omits at least one grouping key from the select list
QSM-02138: agg(expr) requires corresponding agg(expr*expr) function
QSM-02140: agg(expr) requires corresponding SUM(expr*expr) function
QSM-02125: subquery join conditions don't meet requirements for capability
QSM-02036: in-list present in materialized view
QSM-02118: duplicate grouping sets
QSM-02132: agg(expr) requires corresponding COUNT(expr) function
QSM-01079: DML operation occurred on a table referenced by MV, string
QSM-02175: some query block in UNION ALL MV is not fast refreshable