Reg:materialized view query rewrite

[gopu_g]

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

[PAVB]

Are you quering dictionary tables or views?... meaning, does your MV query selects from dictionary tables or views?

[gopu_g]

From views

[PAVB]

oerr QSM 1263
01263, 00000, "query rewrite not possible when query references a dictionary table or view"
// *Cause:    Query rewrite is not allowed if query references any dictionary
//            tables/views.
// *Action:   none

[gopu_g]

That means query rewrite is not happening ?

but here it shows that it is happening...why it is showing like that ?
SQL> select operation,object_name from plan_table;

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

[PAVB]

don't ask me, ask Oracle by tracing it, trace would show the truth

[gopu_g]

thanks

[gopu_g]

thanks pavb for the valuable answers....

i got the answer....



MESSAGE
--------------------------------------------------
QSM-01151: query was rewritten
QSM-01209: query rewritten with materialized view,
MV_BIGTAB, using text match algorithm

[gopu_g]

thanks pavb for the valuable answers....

i got the answer....

SQL> select message from rewrite_table;

MESSAGE
--------------------------------------------------------------------------------
QSM-01151: query was rewritten
QSM-01209: query rewritten with materialized view, MV_BIGTAB, using text match a
lgorithm