QSM-02153: view or subquery in FROM list not supported for this type materialized view

QSM-01081: no primary key or row id found for table, string, in MV, string

QSM-02005: named view in FROM list

QSM-02019: materialized view references another materialized view in FROM clause

QSM-02143: SUM(expr) without COUNT(expr)

QSM-02171: the materialized view has a join operation in the outer UNION block

QSM-02009: non-inner join

QSM-02078: materialized view log must have new values

QSM-02086: materialized view uses the MIN or MAX aggregate functions

QSM-02088: materialized view omits at least one grouping key from the select list

QSM-02054: DISTINCT clause in select list in materialized view

QSM-02129: join or filter conditions are complex

QSM-01085: materialized view, string, has a lossy join between tables, string

QSM-02070: PCT not supported with this type of partitioning

QSM-02075: materialized view on synonym

QSM-02147: default date format is sensitive to session settings

QSM-01055: Query Rewrite failed to allocate the necessary materialized view join graph

QSM-01080: invalid dimension, string

QSM-01087: query grouping on a column that cannot be derived from materialized view, string

QSM-01094: outer-join filter not found in materialized join view

QSM-02022: aggregate selections

QSM-02033: no filter conditions are present in the WHERE clause

QSM-02036: in-list present in materialized view

QSM-02053: collection subquery in materialized view

QSM-02118: duplicate grouping sets

QSM-02121: set operator in a context not supported for fast refresh

QSM-01095: no suitable grouping_id found in materialized view with grouping sets

QSM-02179: MV with UNION ALL requires compatibility >= 9.2.0

QSM-01079: DML operation occurred on a table referenced by MV, string

QSM-02127: not supported for this type materialized view by Oracle version at master site

QSM-02176: MV with UNION ALL in a view is too complex

QSM-01077: materialized view, string, is grouping at a higher level than query

QSM-02026: non-AND conjunction in WHERE clause

QSM-02037: cannot evaluate constant expression at compile time

QSM-02056: correlated variable and outer join in materialized view

QSM-02104: aggregate function in a filter condition in the HAVING clause

QSM-02115: materialized view references a remote object and is refreshed ON COMMIT

QSM-01044: join back attempted on a view for string

QSM-01069: summary join graph for, string, does not have table, string

QSM-02039: top level materialized view query uses grouping sets

QSM-02063: aggregate function in materialized view

QSM-02101: materialized view references a synonym in the FROM list

QSM-02145: GROUP BY clause is present but no aggregate functions are used

QSM-02008: non-join filter condition in WHERE or HAVING clause

QSM-02034: no joins are present in the HAVING clause

QSM-02057: ROWNUM referenced in materialized view

QSM-02066: Oracle error: see RELATED_NUM and RELATED_TEXT for details

QSM-02072: requirements not satisfied for fast refresh of nested materialized view

QSM-02092: materialized view references a sequence number

QSM-02154: MV is not fast refreshable even with view merging