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

13 Materialized Views Messages (12000 Through 12329)
SQL 12001
12001 Creation failed. The materialized view cannot be maintained
incrementally.
Cause You specified an incremental materialized view and used a query expression that is
not supported as incremental.
Effect The creation of the materialized view fails.
Recovery Change the materialized view definition and resubmit the create statement.
SQL 12005
12005 Materialized view mv-name is not found in metadata table name.
mv-name
is a materialized view.
name
is the metadata table.
Cause The HP Neoview database software found a discrepancy while reading metadata
information. The information returned is inconsistent. This is an internal error.
Effect The operation fails.
Recovery Contact HP support.
SQL 12006
12006 Incremental materialized views must have a simple query: name.
name
is an object.
Cause The materialized view query expression is not valid.
Effect The creation of the materialized view fails.
Recovery Rewrite the materialized view query expression and resubmit the statement.
SQL 12008
12008 Creation of the table holding the materialized view failed.
Cause The physical table that will hold the materialized view data could not be created.
Effect The creation of the materialized view fails.
Recovery Resubmit the create statement. If the issue persists, contact the GMCSC.
SQL 12009
12009 Object name cannot be dropped because it is being used by
materialized view mv-name.
name
is an object.
mv-name
is a materialized view.
Cause You attempted to drop an object that is a either a table, a view or a materialized view,
that is being used by some materialized view.
Effect The object cannot be dropped while the mentioned materialized view exists.
Recovery Drop the mentioned materialized view first.
237