Oracle Error QSM-01214: query rewrite not possible if OR is the top level operator in query WHERE clause

Oracle Error Message

QSM-01214: query rewrite not possible if OR is the top level operator in query WHERE clause

Reason for the Error

If the top-level operator in the WHERE clause is an OR and there is more than one table in the FROM list, then query rewrite will not take place.

Solution

None