Set the following session parameters to enable query rewrite:
SQL> SQL> ALTER SESSION SET QUERY_REWRITE_ENABLED=TRUE; Session altered. SQL> ALTER SESSION SET QUERY_REWRITE_INTEGRITY=ENFORCED; Session altered. SQL> SQL> --