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


QSM-02175: some query block in UNION ALL MV is not fast
refreshable



QSM-02175: some query block in UNION ALL MV is not fast refreshable..

Answer / guest

Cause: For a materialized view with UNION ALL to be fast
refreshable, each query block must conform to a fast
refreshable materialized join view or materialized aggregate
view.

Action: Check each query block in the UNION ALL to ensure it
is either a materialized view with joins or aggregates.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11506: record ignored on line string because of error(s)

1 Answers  


PLS-00503: RETURN <value> statement required for this return from function

1 Answers  


NZE-28758: memory release failure

1 Answers  


ORA-00483: During shutdown a process abnormally terminated

1 Answers  


ORA-13761: invalid filter

1 Answers  






ORA-04099: trigger 'string' is valid but not stored in compiled form

1 Answers  


ORA-38423: Attribute set created from an ADT may not be extended.

1 Answers  


PLS-00111: end-of-file in comment

1 Answers  


ORA-01854: julian date must be between 1 and 5373484

1 Answers  


SQL*Loader-00533: OCI return status: unknown, value is number

1 Answers  


ORA-13525: error with computing space usage for sysaux occupant

1 Answers  


ORA-01484: arrays can only be bound to PL/SQL statements

1 Answers  






Categories