QSM-02174: the materialized view does not have a UNION ALL
marker column



QSM-02174: the materialized view does not have a UNION ALL marker column..

Answer / guest

Cause: For a materialized view with UNION ALL to be fast
refreshable, it must have a UNION ALL marker column. This is
a constant column, at the same ordinal position in each
query block and must have distinct values in each query block.

Action: Add a UNION ALL marker column to each query block in
the UNION ALL query defining the materialized view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25145: allocation policy already specified

1 Answers  


ORA-24421: OCISessionRelease cannot be used to release this session.

1 Answers  


ORA-01042: detaching a session with open cursors not allowed

1 Answers  


RMAN-04022: target database mount id string does not match channel's mount id string

1 Answers  


ORA-12003: materialized view "string"."string" does not exist

1 Answers  






RMAN-08027: channel string: copied current controlfile

1 Answers  


ORA-32154: Anydata context not specified

1 Answers  


ORA-07742: slemop: $CONNECT failure

1 Answers  


ORA-30185: output too large to fit in the buffer

1 Answers  


TNS-04068: Cannot start an Oracle Connection Manager instance remotely.

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  


ORA-07236: slemop: open error.

1 Answers  


Categories