QSM-02020: container column not in SELECT list with NOT NULL
constraint
- 1 Answers
- 2407 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 |
KUP-04044: error positioning file string
ORA-25191: cannot reference overflow table of an index-organized table
RMAN-06501: skipping datafile string; already backed up on string
DRG-11303: secondary indexes are not supported by this indextype
ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
PROC-00023: Error in cluster services layer
ORA-31628: error getting worker process exception
ORA-25239: message ID not supplied when dequeuing from exception queue string.string
NNO-00302: server stopped
PCC-01515: FIPS warning: Undeclared host variable "string" at line number in file string
ORA-04099: trigger 'string' is valid but not stored in compiled form
LSX-00340: improper namespace value for the imported element
Oracle Errors 
