QSM-02177: MV with UNION ALL in a view must match the view's
SELECT list



QSM-02177: MV with UNION ALL in a view must match the view's SELECT list..

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

Post New Answer

More Oracle Errors Interview Questions

PCC-02352: out of bounds bind position from PL/SQL

1 Answers  


SQL*Loader-00528: OCI return status: error

1 Answers  


ORA-22909: exceeded maximum VARRAY limit

1 Answers  


TNS-00092: * CMANAGER (or intlsnr) - will ask the Cmanager only

1 Answers  


ORA-29951: warning in the execution of ODCIINDEXSPLITPARTITION routine

1 Answers  






NNO-00851: LDAP open/bind failed: error = number

1 Answers  


ORA-09933: Deletion of old password file failed.

1 Answers  


ORA-14644: table is not subpartitioned by Hash method

1 Answers  


ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

1 Answers  


ORA-19910: can not change recovery target incarnation in controlfile

1 Answers  


LPX-00411: unknown function name encountered

1 Answers  


RMAN-08510: archive log thread=string sequence=string

1 Answers  


Categories