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

ORA-33247: (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


ORA-06408: NETCMN: incorrect message format

1 Answers  


PCC-02046: CMD-LINE: Unable to open config file:

1 Answers  


ORA-31029: Cannot bind to unsaved resource

1 Answers  


NZE-29016: inadequate PKCS1 message padding

1 Answers  






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

1 Answers  


TNS-01018: save_config [<listener_name>]: saves configuration changes to parameter file

1 Answers  


ORA-31016: Attempted to delete entry without name

1 Answers  


ORA-29340: export file appears to be corrupted: [string] [string] [string]

1 Answers  


ORA-01881: timezone region id number is invalid

1 Answers  


DRG-11709: too many terms in thesaurus

1 Answers  


ORA-01077: background process initialization failure

1 Answers  


Categories