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
- 2915 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 |
NID-00390: These files must be writable by this utility.
ORA-32130: invalid offset/index refrenced in Bytes
CLSR-00005: Error encountered during memory allocation
PCC-02343: body of cursor must be a query expression
RMAN-06186: PL/SQL package string.string version string in string database is too old
ORA-07741: slemop: $OPEN failure
ORA-02329: column of datatype string cannot be unique or a primary key
ORA-26664: cannot create STREAMS process string
ORA-28661: Object already has COMPRESS clause specified
ORA-30191: missing argument list
NNL-00207: Scheduled reload check to occur in string
IMP-00054: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
Oracle Errors 
