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


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-07406: slbtpd: invalid number.

1 Answers  


RMAN-10030: RPC call appears to have failed to start on channel string

1 Answers  


ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.

1 Answers  


ORA-31421: change table does not exist

1 Answers  


ORA-07214: slgunm: uname error, unable to get system information.

1 Answers  






RMAN-06502: skipping archive log file string; already backed on string

1 Answers  


ORA-01246: recovering files through TSPITR of tablespace string

1 Answers  


ORA-06578: output parameter cannot be a duplicate bind

1 Answers  


ORA-09981: skxfqdreg: Error Adding a page to the SDI buffer pool

1 Answers  


ORA-21610: size [string] is invalid

1 Answers  


ORA-31461: logfile location string contains no files that match pattern string

1 Answers  


NID-00304: Datafile string - reverted

1 Answers  






Categories