Neoview Messages Manual (R2.3)
SQL 12116
12116 The IGNORE CHANGES clause of materialized view mv-name cannot be
altered when the COMMIT REFRESH EACH mvattribute is specified and the
alter causes the materialized view to change from tracking changes on
one base table to multiple base tables.
mv-name
is a materialized view.
Cause An attempt was made to alter a materialized view such that the materialized view
is now tracking changes on more than one table. When the COMMIT REFRESH EACH attribute
is specified, the materialized view can only track changes on a single table.
Effect The operation fails.
Recovery Try altering the materialized view and remove the COMMIT REFRESH EACH
attribute and resubmit or only track changes on a single table.
SQL 12201
12201 MVGroup mv-group does not exist.
mv-group
is a materialized views group.
Cause You used the name of an MVGroup that does not exist.
Effect The operation failed.
Recovery Correct the syntax and resubmit.
SQL 12202
12202 Materialized view mv-name does not exist.
Cause You specified a name of a materialized view that does not exist.
Effect The operation failed.
Recovery Correct the syntax and resubmit.
SQL 12203
12203 Materialized view mv-name already exists in MVGroup.
mv-name
is a materialized view.
Cause The materialized view is already in the materialized view group.
Effect The operation failed.
Recovery None.
SQL 12204
12204 The materialized view or MV group does not exist.
Cause You specified a name of a materialized view or MVGroup that do not exist.
Effect The operation failed.
Recovery Correct the syntax and resubmit.
SQL 12205
12205 Group mvgroup not empty. Must be empty before drop.
mvgroup
is an MVGroup.
Cause An MVGroup must be empty in order to drop it.
Effect The operation failed.
Recovery Remove all the materialized views from the MVGroup and try again.
236 Materialized Views Messages (12000 Through 12329)