QSM-02176: MV with UNION ALL in a view is too complex



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

Post New Answer

More Oracle Errors Interview Questions

ORA-01345: Supplemental log data must be enabled to build into the logstream

1 Answers  


RMAN-08007: channel string: copied datafilecopy of datafile string

1 Answers  


ORA-08460: invalid environment clause in environment parameter

1 Answers  


ORA-36728: (XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded.

1 Answers  


PCC-00005: Unsupported datatype in line number of file string

1 Answers  






ORA-26063: Can not flashback to specified SCN value - Wrap: string Base: string.

1 Answers  


ORA-25272: Signature does not exist for the given reciever and message id.

1 Answers  


O2F-00308: No type specifications were seen in the INTYPE file

1 Answers  


SQL*Loader-00709: Internal error calling SLTS layer: string failed

1 Answers  


ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified

2 Answers  


LSX-00240: bad float "~S"

1 Answers  


KUP-00561: invalid length for binary integer field string

1 Answers  


Categories