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-07305: ksmcsg: illegal database buffer size.
PCC-02113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2.
NNO-00272: line string; invalid DIT/DN
ORA-32153: Environment not specified
TNS-12541: TNS:no listener
TNS-00125: Failed to get number of Interchanges in TNSNET.ORA
ORA-26530: unable to build materialized view refresh control list
ORA-09762: sNeXT_instanceName: translation error.
LPX-00283: document encoding is ~s-based but default input encoding is not
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified
DRG-11810: Partial Update OK
ORA-12674: Shared server: proxy context not saved