QSM-02177: MV with UNION ALL in a view must match the view's
SELECT list
- 1 Answers
- 2278 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 |
TNS-12550: TNS:syntax error
NZE-29247: an unopen toolkit object was used before it was opened
ORA-01158: database string already mounted
ORA-01522: file 'string' to be renamed does not exist
PCC-02129: CMD-LINE: Client supplied static options table is invalid
LPX-00201: unknown encoding "~s"
PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy
QSM-02001: clustered mv container table
ORA-23493: "string" is not a new site for extension request "string"
NNL-00934: Requests refused, ALIAS-EXISTS violation: number
PCC-02154: Close file: string
NNL-01000: SERVER FAILURE responses received: number
Oracle Errors 
