Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02176: MV with UNION ALL in a view is too complex
- 1 Answers
- 2770 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
defining query cannot have any clauses other than SELECT or
FROM. Other clauses such as WHERE, HAVING, CONNECT BY, or
GROUP BY are not allowed. Further more, the FROM clause
should have only one item.
Action: Remove any clauses besides SELECT and FROM from the
materialized view's defining query.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
NCR-01003: NCRS: Read error.
QSM-02030: reduced precision specified for prebuilt mv
ORA-02044: transaction manager login denied: transaction in progress
PLS-00454: with a returning into clause, the table expression cannot be remote or a subquery
PCC-01000: You are not authorized to run Pro*COBOL
PCC-00076: DISPLAY type must be SIGN LEADING SEPARATE
LSX-00249: invalid date or time "~S"
ORA-01276: Cannot add file string. File has an Oracle Managed Files file name.
ORA-14289: cannot make local index partition of Composite Range partitioned table unusable
TNS-00290: Navigator: Failed to Enable Interchange
SQL*Loader-00563: bad length for VAR record
O2F-00308: No type specifications were seen in the INTYPE file
Oracle Errors 
