Problem with the partial SQL text match of QUERY REWRITE

Hi,
I would like to get lots of informations on the partial SQL text match of query rewrite because when I execute a query, oracle doesn't use the materialized view that I have created before.
Is it possible with Oracle 8.1.5 ?

Thanks.

Hi;
It should be possible.

Please check the ini.ora-Param

Code:

---


Query_rewrite_enabled # should be set to TRUE
Query_rewrite_integrity # depends on your Need

---

Also there exists a system-privilege :

Code:

---


Query Rewrite

---

Please Check Documentation ( Datawarehouse guide )
Orca

The init.ora is correct