QSM-02020: container column not in SELECT list with NOT NULL
constraint
- 1 Answers
- 3237 Views
- I also Faced
- E-Mail Answers
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-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
ORA-13828: generated SQL profile name string already exists
ORA-06408: NETCMN: incorrect message format
RMAN-06609: AS COPY can be configured only for disk device
ORA-26668: STREAMS process string exists
UDE-00050: Unable to setup parameter processing.
NID-00301: Datafile string - dbid changed, wrote new name
ORA-25443: duplicate column value for table alias: string, column number: string
ORA-39036: invalid metadata filter name string
DRG-52210: error while registering value for attribute: string
ORA-02046: distributed transaction already begun
QSM-02059: join may produce duplicate rows in mv
Oracle Errors 
