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
- 2971 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-01415: Listening Endpoints Summary...
ORA-03248: Too much of segment creation activity during migration
SQL-02151: Invalid host variable for exact numeric SET statement item
ORA-16544: Modifying DG_BROKER_START requires SID='*' qualifier
ORA-28534: Heterogeneous Services preprocessing error
ORA-600?
ORA-01059: parse expected before a bind or execute
LCD-00215: parameter files nested too deep [string]
ORA-01891: Datetime/Interval internal error
RMAN-06141: cannot specify ARCHIVELOG LIKE option with RESTORE
ORA-36671: (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.
ORA-26089: LONG column "string" must be specified last
Oracle Errors 
