Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02020: container column not in SELECT list with NOT NULL
constraint
- 1 Answers
- 3184 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-25275: Test support for buffered queues
ORA-13761: invalid filter
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
NID-00416: Change of database name failed.
PCB-00402: Pseudo-text not properly terminated
NZE-28838: no identity descriptor
ORA-06736: TLI Driver: server not running
DRG-10757: stoplist cannot have more than 4096 stopwords
ORA-37011: (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
ORA-31644: unable to position to block number string in dump file "string"
PCC-00031: Invalid value given for option "string"
NNO-00606: disabling modification requests
Oracle Errors 
