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-25223: user_data type used is not supported
ORA-27419: unable to determine valid execution date from repeat interval
TNS-01303: ns main err code: number
NNC-00419: authoritative server is unreachable
ORA-30104: 'string' is not a legal integer for 'string'
IMG-02002: 2FF02 - incorrect average color feature specification
RMAN-06750: SPFILE cannot be backed up by proxy.
ORA-19717: for non-OMF search the pattern must be specified
ORA-15113: alias name 'string' refers to a directory
ORA-30739: cannot drop a table that has subtables
NNO-00321: statistic counter dump disabled
RMAN-03031: this option of set command needs to be used inside a run block