QSM-02020
container column not in SELECT list with NOT NULL constraint
Cause
The capability in question is not supported when the materialized view's container table has a column that does not correspond to an output expression in the select list, and that column has a NOT NULL constraint. This situation can result in problems during refresh since any new rows inserted into the materialized view will set that column to NULL.
Action
Disable or remove the NOT NULL constraint.
QSM-02020
container column not in SELECT list with NOT NULL constraint
Cause
The capability in question is not supported when the materialized view's container table has a column that does not correspond to an output expression in the select list, and that column has a NOT NULL constraint. This situation can result in problems during refresh since any new rows inserted into the materialized view will set that column to NULL.
Action
Disable or remove the NOT NULL constraint.
QSM-02020
container column not in SELECT list with NOT NULL constraint
Cause
The capability in question is not supported when the materialized view's container table has a column that does not correspond to an output expression in the select list, and that column has a NOT NULL constraint. This situation can result in problems during refresh since any new rows inserted into the materialized view will set that column to NULL.
Action
Disable or remove the NOT NULL constraint.
