How to fix the Oracle error QSM-02179: MV with UNION ALL requires compatibility >= 9.2?

In this post, you’ll learn more about the Oracle ErrorQSM-02179: MV with UNION ALL requires compatibility >= 9.2 with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-02179: MV with UNION ALL requires compatibility >= 9.2

Reason for the Error QSM-02179: MV with UNION ALL requires compatibility >= 9.2

The setting of the COMPATIBLE initialization parameter is less than 9.2.0.

How to fix the Error QSM-02179: MV with UNION ALL requires compatibility >= 9.2 ?

You can fix this error in Oracle by following the below steps

Set COMPATIBLE to 9.2.0 or higher.