QSM-02171: the materialized view has a join operation in the
outer UNION block



QSM-02171: the materialized view has a join operation in the outer UNION block..

Answer / guest

Cause: Fast refresh is not supported if a materialized view
having the UNION operator contains a join operation.

Action: Rewrite the materialized view query without the join.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00609: the OVERRIDING clause is not valid for SQLJ Object Types

1 Answers  


LSX-00123: base type is required

1 Answers  


ORA-01983: invalid auditing option for DEFAULT

1 Answers  


ORA-14631: the partition bounds do not match the subpartition bounds of the partition

1 Answers  


ORA-30568: cannot drop log group - nonexistent log group

1 Answers  






ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

1 Answers  


IMP-00088: Problem importing metadata for index string. Index creation will be skipped

1 Answers  


DRG-11869: Premature End Of File Detected

1 Answers  


ORA-16614: object has an ancestor that is disabled

1 Answers  


ORA-03113: end-of-file on communication channel

1 Answers  


ORA-00346: log member marked as STALE

1 Answers  


ORA-13155: invalid number of dimensions specified

1 Answers  


Categories