QSM-02176: MV with UNION ALL in a view is too complex
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|
SQL*Loader-00286: ROWS parameter is not supported when loading an IOT.
ORA-22974: missing WITH OBJECT OID clause
RMAN-07502: List of Files Unknown to the Database
RMAN-05502: the target database must be mounted when issuing a DUPLICATE command
ORA-16061: Log file status has changed
LFI-00142: Unable to delete an existing file [string][string] not owned by Oracle.
ORA-30101: unknown parameter name 'string'
DRG-10754: memory size must be between string and string
ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
PCC-01010: Invalid use of NULL character in character literal
ORA-02239: there are objects which reference this sequence
RMAN-10012: KGU error: string