Neoview Messages Manual (R2.3)

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.
SQL 12114
12114 ON STATEMENT materialized views using this object.
Cause The table attribute was changed from audit to no audit.This is not allowed when an
ON STATEMENT materialized view is using it.
Effect The operation fails.
Recovery None.
SQL 12115
12115 The IGNORE CHANGES clause of materialized view mv-name cannot be
altered when the logs of the tables referred to in the IGNORE CHANGES
clause are not empty. Refresh the materialized view and try the ALTER
statement again.
mv-name
is a materialized view.
Cause An attempt was made to ALTER IGNORE CHANGES on a base table of the
materialized view and the insert/update/delete logs for the materialized view are not empty.
Effect The operation fails.
Recovery Refresh the materialized view, and then retry the ALTER MV statement.
235