Neoview Messages Manual (R2.2)

Recovery ON STATEMENT MVs and RECOMPUTE MVs do not have the IGNORE
CHANGES clause, so these materialized views cannot be altered.
SQL 12014
12014 Can not initialize; locking of name failed.
name
is a table used by a materialized view being initialized.
Cause A table used by the materialized view cannot be locked, possibly because it is being
used by other applications.
Effect The materialized view cannot be initialized.
Recovery Resubmit the create statement. If the issue persists, contact the GMCSC.
SQL 12015
12015 Creation of a log table for name failed.
name
is a table used by a materialized view.
Cause When a materialized view is created, log tables for its base tables are created as well.
The creation of such log tables failed.
Effect The creation of the materialized view fails.
Recovery Contact the GMCSC.
SQL 12016
12016 Unique indexes are not allowed on materialized views.
Cause Unique indexes are not allowed on materialized views.
Effect The creation of the index fails.
Recovery None.
SQL 12024
12024 A materialized view cannot be initialized when it is using other
materialized views that are not initialized: name.
name
is an existing materialized view.
Cause You attempted to initialize a materialized view that is using a second materialized
view, which is not yet initialized.
Effect The materialized view cannot be initialized.
Recovery Initialize the second materialized view first.
SQL 12027
12027 Materialized views cannot be created on meta data table name.
name
is a metadata table.
Cause Materialized views are supported on user tables only.
Effect The creation of the materialized view fails.
Recovery None.
SQL 12028
12028 Grant update not allowed for Materialized views.
Cause You attempted to grant update privileges on a materialized view.
Effect These privileges cannot be granted.
Recovery None.
222 Materialized Views Messages (12000 Through 12329)