Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02177: MV with UNION ALL in a view must match the view's
SELECT list
- 1 Answers
- 2853 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: If a materialized view has a view whose definition
involves a UNION ALL query, then the materialized view's
select list must match the underlying view's select list
exactly. It must not have any expressions and must not have
add/drop/reorder columns from the underlying view.
Action: Use select * when defining a materialized view with
a UNION ALL in a view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-02762: file number to be cancelled is greater than the maximum.
ORA-24344: success with compilation error
NZE-28805: Cannot retrieve information from the data source.
ORA-13830: SQL profile with category string already exists for this SQL statement
ORA-38417: attribute set string does not exist
PCC-02035: CMD-LINE: CONFIG= option is invalid in a config file
ORA-12482: internal MLS error: string Error: string
PCC-02425: An indicator variable is not required with this attribute
DRG-10511: index string does not exist or is incomplete
ORA-38723: Invalid SCN expression.
DRG-11837: Reauthorization Required
PLS-00236: Invalid external type specification for string.
Oracle Errors 
