hi
when i taken the explain plan of the MV,the output is like this

Elapsed: 00:00:00.04
SQL> select operation,object_name from plan_table;

OPERATION OBJECT_NAME
------------------------------ --------------------
SELECT STATEMENT
MAT_VIEW REWRITE ACCESS MV_BIGTAB

means the query rewite is happening
........

but when i checked the same thing using the dbms_mview.explain_rewrite
the output i got is..

SQL> select message from rewrite_table order by sequence;

MESSAGE
--------------------------------------------------------------------------------
QSM-01150: query did not rewrite
QSM-01263: query rewrite not possible when query references a dictionary table o
r view

it is saying the query did not rewirte...

i am new to MV and the query rewrite....
why it is showing like this

gopu