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-10851: Invalid grammar string specified for query template

1 Answers  


ORA-01268: invalid TEMPFILE clause for alter of permanent TABLESPACE

1 Answers  


NNL-00580: register_ns: <name server> <address> <domain>

1 Answers  


NNC-00417: name "string" already exists

1 Answers  


EXP-00017: feature "string" is needed, but not present in database

1 Answers  






ORA-31665: mode can only be defaulted for IMPORT and SQL_FILE operations

1 Answers  


ORA-30502: system triggers cannot have INSERT, UPDATE, or DELETE as triggering events

1 Answers  


RMAN-04015: error setting target database character set to string

1 Answers  


ORA-14645: STORE IN clause cannot be specified for Range List objects

1 Answers  


ORA-01215: enabled thread string is missing after CREATE CONTROLFILE

1 Answers  


ORA-07441: function address must be aligned on string byte boundary

1 Answers  


ORA-25009: Nested table clause allowed only for INSTEAD OF triggers

1 Answers  


Categories