Errores QSM
Errores QSM mas frecuentes
QSM-01025: materialized view, string, not found
QSM-01020: materialized view, string, is ineligible
QSM-02180: no primary key constraint in the master table
QSM-02091: materialized view references a non-repeatable or session-sensitive expression
QSM-00514: the size of must-retain summaries exceeds specified space limit
QSM-02082: problem with materialized view log
QSM-01056: no query rewrite for this DDL expression
QSM-02053: collection subquery in materialized view
QSM-01102: materialized view, string, requires join back to table, string, on column, string
QSM-02049: subquery using the ANY clause in materialized view
QSM-02083: materialized view references PL/SQL function that maintains state
QSM-01061: illegal query expression
QSM-02154: MV is not fast refreshable even with view merging
QSM-02137: agg(expr) requires corresponding STDDEV(expr) function
QSM-02018: subquery present in the WHERE clause
QSM-01091: cost based optimizer found query rewrite is more expensive
QSM-01094: outer-join filter not found in materialized join view
QSM-02025: no aggregate functions
QSM-02064: subquery in materialized view
QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY columns
QSM-01081: no primary key or row id found for table, string, in MV, string
QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing
QSM-02031: materialized view cannot support any type of query rewrite
QSM-01063: query has a dictionary table or view
QSM-01060: illegal subquery in the HAVING clause
QSM-02011: a HAVING clause is present
QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode
QSM-02128: does not meet the requirements of a primary key materialized view
QSM-02161: see the reason why REFRESH_FAST_AFTER_ONETAB_DML is disabled
QSM-02038: Partition Change Tracking (PCT) is enabled
QSM-02171: the materialized view has a join operation in the outer UNION block
QSM-02021: set operator encountered in materialized view
QSM-02005: named view in FROM list
QSM-02081: materialized view log does not have all necessary columns
QSM-02041: nested aggregate function
QSM-02146: see the reason why REFRESH_FAST_AFTER_INSERT is disabled
QSM-02147: default date format is sensitive to session settings
QSM-01071: a lossy join in materialized view, string, from table, string, not found in query
QSM-02020: container column not in SELECT list with NOT NULL constraint
QSM-01098: materialized view string clause more restrictive than query string clause
QSM-02113: expression in select list references multiple tables or views
QSM-01062: query has one or more manual partition(s)
QSM-01077: materialized view, string, is grouping at a higher level than query
QSM-02099: materialized view references a remote table or view in the FROM list
QSM-02067: no partition key or PMARKER in select list
QSM-02075: materialized view on synonym
QSM-02176: MV with UNION ALL in a view is too complex
QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode
QSM-01093: anti-join marker not found in materialized join view
QSM-02115: materialized view references a remote object and is refreshed ON COMMIT