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-14059: partition "string": INITRANS value must be less than MAXTRANS value

1 Answers  


RMAN-08507: input datafilecopy recid=string stamp=string filename=string

1 Answers  


RMAN-06703: could not open file: "string" (reason=string)

1 Answers  


ORA-30179: invalid argument index used in a format code

1 Answers  


RMAN-20215: backup set not found

1 Answers  






ORA-13054: recursive SQL parse error

1 Answers  


ORA-02190: keyword TABLES expected

1 Answers  


ORA-13859: Action cannot be specified without the module specification

1 Answers  


TNS-02525: encryption/crypto-checksumming: self test failed

1 Answers  


RMAN-06577: FROM TAG option may only be used with datafilecopies

1 Answers  


TNS-01015: set|show parm_name [<value>]: sets|shows current listener parm values

1 Answers  


ORA-13784: cannot accept SQL profiles for all statements in the "SQL Tuning Set"

1 Answers  


Categories