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

SQL*Loader-00909: Loader views must be loaded (as SYS) for direct path to be used

1 Answers  


SQL*Loader-00122: Invalid skip_index_maintenance option

1 Answers  


TNS-01076: Opened trace file: string

1 Answers  


ORA-13852: Tracing for service(module/action) string is not enabled

1 Answers  


DRG-11514: user string does not have UPDATE or SELECT privilege on string

1 Answers  


ORA-22878: duplicate LOB partition or subpartition specified

1 Answers  


ORA-27457: argument string of job "string.string" has no value

1 Answers  


ORA-02708: osnrntab: connect to host failed, unknown ORACLE_SID

1 Answers  


PCC-02144: CMD-LINE: Blank characters are not allowed on either side of an equal sign (=)

1 Answers  


ORA-06563: top level procedure/function specified, cannot have subparts

1 Answers  


ORA-23359: error on creating a ddl record for a repcatlog record

1 Answers  


PCC-00095: Missing PROGRAM, SUBROUTINE, FUNCTION, or BLOCK DATA statement

1 Answers  


Categories