Oracle Error ORA-30387: invalid rewrite mode for REWRITE_EQUIVALENCE API

Oracle Error Message

ORA-30387: invalid rewrite mode for REWRITE_EQUIVALENCE API

Reason for the Error

The specified rewrite mode is not supported by REWRITE_EQUIVALENCE API

Solution

Verify the rewrite mode is supported by REWRITE_EQUIVALENCE API