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-22165: given index [string] must be in the range of 0 to [string]

1 Answers  


ORA-00020: maximum number of processes (string) exceeded

2 Answers  


LFI-00102: Unable to seek in sequentially accessed file.

1 Answers  


CLSR-00525: prsr initialization failed

1 Answers  


ORA-28134: object cannot have fine-grained access control policy

1 Answers  






ORA-36806: (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.

1 Answers  


DRG-10821: contains cursor is not open

1 Answers  


ORA-03293: Cluster to be truncated is a HASH CLUSTER

1 Answers  


DRG-51101: argument processing callback failed

1 Answers  


ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here

2 Answers  


ORA-29250: Invalid index specifed in call to dbms_sql.bind_array

1 Answers  


RMAN-06407: auxiliary instance datafile string deleted

1 Answers  


Categories