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
- 2884 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-24809: amount specified will not fit in the lob buffers
PLS-00655: only functions can be declared as PIPELINED
RMAN-06084: the target database may not be mounted when issuing REPLICATE
ORA-32629: measure used for referencing cannot be updated
ORA-16109: failed to apply log data from previous primary
ORA-23418: cannot unregister the propagator who is currently in use
DRG-12007: You might not be allowed to use this method here, continue?
ORA-28302: User does not exist in the LDAP directory service.
ORA-09363: Windows 3.1 Two-Task driver invalid context area
ORA-15108: missing or invalid template name
IMG-00522: invalid format for parameter value
ORA-32302: object materialized views must be object ID based
Oracle Errors 
