QSM-01104: query is using flashback

QSM-02011: a HAVING clause is present

QSM-02016: clustered table in FROM list

QSM-02044: ORDER BY clause in materialized view

QSM-02050: subquery using the ALL clause in materialized view

QSM-02052: subquery using a select list in materialized view

QSM-02068: relation is not a partitioned table

QSM-02073: non-primary key RepAPI materialized view is not fast refreshable

QSM-02120: compatibility mode must be 9.0 or higher

QSM-02133: agg(expr) requires corresponding MIN(expr) function

QSM-02140: agg(expr) requires corresponding SUM(expr*expr) function

QSM-01046: complex join back on correlated columns not allowed (string)

QSM-01100: containment check failed for mv, string

QSM-01101: rollups took place on mv, string

QSM-02004: grouping column omitted from SELECT list

QSM-02017: subquery present in the HAVING clause

QSM-02023: nested cursor

QSM-02055: materialized view references a packed object table or view

QSM-02102: materialized view FROM list references an object in the SYS schema

QSM-02130: expression not supported for fast refresh

QSM-01048: join back level(s) not present (string)

QSM-01073: materialized view, string, has a join not found in query

QSM-02001: clustered materialized view container table

QSM-02029: PL/SQL function invocation

QSM-02031: materialized view cannot support any type of query rewrite

QSM-02045: START WITH clause in materialized view

QSM-01097: Materialized view with grouping sets has too long key

QSM-02040: top level query contains GSets and the key is too long for rewrite

QSM-02128: does not meet the requirements of a primary key materialized view

QSM-01051: no support for rollup when a window function is present on the column

QSM-02024: no GROUP BY clause

QSM-02025: no aggregate functions

QSM-02122: compatibility mode must be 8.1 or higher

QSM-01047: complex join back on non-MAV rewrite not allowed (string)

QSM-02020: container column not in SELECT list with NOT NULL constraint

QSM-02119: internal error while analyzing required supporting aggregates

QSM-02131: agg(expr) requires corresponding SUM(expr) function

QSM-02006: subquery in FROM list

QSM-02028: group by CUBE

QSM-02071: internal error: undefined PCT failure code

QSM-02096: materialized view references a named view

QSM-02136: agg(expr) requires corresponding VARIANCE(expr) function

QSM-02152: subquery or named view in FROM list even after view merging

QSM-02003: aggregate function nested within an expression

QSM-02062: GROUP BY clause in materialized view

QSM-02099: materialized view references a remote table or view in the FROM list

QSM-01074: materialized view, string, and query have different no of joins between tables, string

QSM-02032: no joins are present in the WHERE clause