Neoview Messages Manual (R2.2)

Effect This is an informational message. The materialized view is created successfully.
Recovery None, but you can drop and recreate the materialized view with the recommended
STORE BY clause to improve refresh performance.
SQL 12110
12110 The materialized view mv-name and its dependents were dropped due
to insufficient privileges.
mv-name
is the name of the dropped materialized view.
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 currently 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 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 12115
12115 Cannot alter the IGNORE CHANGES clause when the logs are not
empty. Please refresh the MV and try again.
Cause The base tables added to the IGNORE CHANGES clause on which the materialized
view (MV) is defined have been updated but the changes are not yet reflected in the materialized
view.
Effect The operation fails.
Recovery Refresh the materialized view, and then retry the ALTER MV statement.
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.
226 Materialized Views Messages (12000 Through 12329)