HP Neoview Messages, Руководство пользователя

Страница: 252 / 400

name
is an unaudited table.
Cause
Materialized views that use unaudited tables are not supported.
Effect
The creation of the materialized view fails.
Recovery
Correct the syntax and resubmit.
SQL 12011
12011 The materialized view cannot be altered. ON STATEMENT and RECOMPUTE
materialized views do not contain an IGNORE CHANGES clause.
Cause
The materialized view (MV) being altered is not an ON REQUEST MV to alter the
IGNORE CHANGES clause.
Effect
The operation fails.
Recovery
ON STATEMENT MVs and RECOMPUTE MVs do not have the IGNORE
CHANGES clause, so these materialized views cannot be altered.
SQL 12014
12014 The materialized view cannot be initialized; 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 an MVlog 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
An attempt was made to create a unique index on a materialized view.
Effect
The operation fails.
Recovery
None.
SQL 12020
12020 A duplicate of table name is present in the IGNORE CHANGES clause.
name
is a table.
Cause An attempt was made to submit a statement with an IGNORE CHANGES clause
which includes a table name more than once.
Effect
The operation fails.
Recovery
Resubmit with every table name in the IGNORE CHANGES clause used only
once.
252 Materialized Views Messages (12000 Through 12329)