Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-02178: MV has a view with UNION ALL that is not fast
refreshable



QSM-02178: MV has a view with UNION ALL that is not fast refreshable..

Answer / guest

Cause: The materialized view has a view whose definition
involves a UNION ALL query that does not satisfy the
requirements for fast refresh.

Action: Check that the defining query of the view being
referenced in the materialized view satisfies conditions for
fast refresh of a UNION ALL materialized view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-37060: (XSMCSESS08) number is not a valid custom member in dimension workspace object.

1 Answers  


LFI-00134: Unable to protect a file for an append operation.

1 Answers  


ORA-27033: failed to obtain file size limit

1 Answers  


ORA-38496: Expression Filter index is not in a valid state

1 Answers  


PCC-00007: Invalid WHENEVER condition at column number in line number of file string

1 Answers  






ORA-13182: failed to read element string.string.string

1 Answers  


ORA-01518: CREATE DATABASE must specify more than one log file

1 Answers  


ORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.

1 Answers  


QSM-02059: join may produce duplicate rows in mv

1 Answers  


ORA-16531: unable to post message

1 Answers  


SQL*Loader-00941: Error during describe of table string

1 Answers  


PLS-00142: duplicate external PARAMETER list specification in subprogram expression

1 Answers  






Categories