Neoview Messages Manual (Volume 1) (R2.4)

Effect The creation of the materialized view fails.
Recovery Add one or more non-null columns as group by columns and resubmit the create
materialized view statement.
SQL 12109
12109 To ensure optimal Refresh performance, the STORE BY clause should
include the following GROUP BY columns: col-names.
col-names
are the group by columns that should be included in the STORE BY clause.
Cause To improve the materialized view refresh performance, the specified columns should
have been included in the STORE BY clause.
Effect This is an informational message. The materialized view is created successfully.
Recovery None, but you can drop and recreate the materialized view with the recommended
STORE BY clause to improve refresh performance.
SQL 12110
12110 The materialized view mv-name and its dependents were dropped
because of insufficient privileges.
mv-name
is the name of the dropped materialized view.
Cause Privileges on the materialized view base table were revoked from the materialized
view owner.
Effect The materialized view and its dependent objects (such as views or other materialized
views created on this materialized view) are dropped.
Recovery None. If you need to recover the dropped materialized view, the revoked privileges
need to be acquired and the materialized view recreated.
SQL 12111
12111 NO AUDIT materialized views are not supported.
Cause You specified a materialized view that is not audited.
Effect The creation of the materialized view fails.
Recovery Correct the syntax and resubmit.
SQL 12112
12112 A secondary index index-name was created for the materialized
view.
index-name
is a system-added secondary index.
Cause You created an incremental materialized view.
Effect This is an informational message. For optimal refresh performance, the system added
the mentioned secondary index to the materialized view.
Recovery None.
SQL 12113
12113 ON STATEMENT MAVs and MAJVs are currently not supported.
Cause ON STATEMENT materialized aggregate views are not supported.
Effect The operation fails.
Recovery Create materialized aggregate views as ON REQUEST.
244 Materialized Views Messages (12000 Through 12329)