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-36776: (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
NZE-28812: record operation failure
ORA-02320: failure in creating storage table for nested table column string
ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
ORA-24123: feature string is not yet implemented
TNS-00040: INTCTL: failed to initialize trace context- Continuing anyway
LSX-00132: attribute "~1S" has invalid occurrences value "~2S"
ORA-33020: (XSAGDNGL09) In AGGMAP workspace object, the MIN argument of number must be less than the MAX argument of number.
ORA-30186: '' must be followed by four hexdecimal characters or another ''
ORA-16412: ONDEMAND archival requires active SQL apply operation
ORA-31697: aborting operation at process order number string
SQL*Loader-00132: invalid argument for external table option