Query rewrite is a very useful concept provided by Oracle so that queries on a table can be redirected to a Materialized view. I am not too familiar with this, so that will be the topic of another post.
This is a quick post about the settings on the database to enable query rewrite.
The following query helps in knowing the settings:
show parameter rewrite
In the results, the query_rewrite_enabled property must be true.
If it is false, query rewrite will not happen
To set it to true, use the following:
alter system set query_rewrite_enabled = TRUE ;
