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-12658: ANO service required but TNS version is incompatible

1 Answers  


TNS-12545: Connect failed because target host or object does not exist

1 Answers  


RMAN-08051: cataloged archive log

1 Answers  


NZE-28779: no data access method specified in parameter

1 Answers  


DRG-52205: class string and object string already exists for this index

1 Answers  






ORA-01051: deferred rpc buffer format invalid

1 Answers  


ORA-22926: specified trim length is greater than current LOB value's length

1 Answers  


RMAN-12018: channel string disabled, job failed on it will be run on another channel

1 Answers  


NID-00308: Control File string - dbid changed

1 Answers  


ORA-31454: invalid value string for operation parameter, expecting: ADD or DROP

1 Answers  


NNO-00054: invalid domain name "string"

1 Answers  


ORA-02754: osnfsmmap: cannot change shared memory inheritence

1 Answers  


Categories