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
- 2882 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-37116: OLAP API table function error: (string)
TNS-12596: TNS:internal inconsistency
ORA-01510: error in deleting log files
PCC-02144: CMD-LINE: Blank characters are not allowed on either side of an equal sign (=)
NZE-29042: Read buffer is not empty.
RMAN-06544: Do you really want to delete the above objects (enter YES or NO)?
ORA-04092: cannot string in a trigger
ORA-12429: label list range exceeded
ORA-16130: supplemental log information is missing from log stream
ORA-25328: %s argument size string is smaller than array size
KUP-04076: file name cannot contain a path specification: string
NNL-00542: restart [<server_list>] : restart one or more Names servers
Oracle Errors 
