QSM-02020: container column not in SELECT list with NOT NULL
constraint
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-26022: index string.string was made unusable due to:
NNO-00153: warning: hint domain number has invalid name "string", hint domain ignored
PCC-00036: No input file name specified
ORA-12492: DBLOW cannot be changed
ORA-01510: error in deleting log files
PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP
DRG-50101: CORE LEM error: string
ORA-14061: data type or length of an index partitioning column may not be changed
NNL-00244: Processing of modification requests is now disabled
TNS-00232: Unable to setup connection
ORA-29824: operator is invalid
QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type