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-30680: debugger connection handshake failed

1 Answers  


RMAN-10018: error cleaning up channel context

1 Answers  


ORA-02721: osnseminit: cannot create semaphore set

1 Answers  


ORA-38755: Flashback is already turned on for this tablespace.

1 Answers  


LPX-00105: element "~S" is not empty as required by the DTD

1 Answers  






ORA-19760: error starting change tracking

1 Answers  


IMP-00051: Direct path exported dump file contains illegal column length

1 Answers  


TNS-00528: Protocol Adapter not loaded

1 Answers  


ORA-25138: %s initialization parameter has been made obsolete

1 Answers  


ORA-16039: RFS request version mismatch

1 Answers  


TNS-00082: NOTE: the user MUST specify a trace level

1 Answers  


NNL-00953: Cache lookup exact matches: number

1 Answers  


Categories