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-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT

1 Answers  


SQL*Loader-00565: unexpected error during skip .

1 Answers  


ORA-14057: partition "string": sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-12680: Native services disabled but required

1 Answers  


LPX-00245: extra data after end of document

1 Answers  


ORA-14082: new partition name must differ from that of any other partition of the object

1 Answers  


ORA-01127: database name 'string' exceeds size limit of string characters

1 Answers  


ORA-28508: invalid value string for Heterogeneous Services initialization parameter string

1 Answers  


ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance

1 Answers  


ORA-39150: bad flashback time

1 Answers  


ORA-23367: table string is missing the primary key

1 Answers  


ORA-15041: diskgroup space exhausted

1 Answers  


Categories