I 'VE CREATE TABLE REWRITE_TABLE and my MV MIKEVW.SSMV_SS_QRW' without enable rewrite query option !
I run this script follow, and i've got no row in REWRITE TABLE !!
anybody can tell me why ?

declare
l_stmt varchar2(2000);
begin
l_stmt := 'SELECT a.ROWID AS rowid_tb , b.ROWID AS rowid_ti , a.NUM_DOS , a.COD_SO from coradwh.TB_DOSSIER_RFTB a, coradwh.TI_CLE_QYOU_DOS_
RFTB b where a.NUM_DOS = b.NUM_DOS';

dbms_mview.explain_rewrite
(
query => l_stmt,
mv => 'MIKEVW.SMV_SS_QRW',
statement_id => '123'
);
end;
/
commit
/
select message from rewrite_table
/

Log :
SQL> set echo on
SQL> @test_explain_rewrite.sql
SQL> declare
2 l_stmt varchar2(2000);
3 begin
4 l_stmt := 'SELECT a.ROWID AS rowid_tb , b.ROWID AS rowid_ti , a.NUM_DOS , a.COD_SO from coradwh.TB_DOSSIER_RFTB a, coradwh.TI_CLE_QYOU_DOS_RFTB b where a.NUM_DOS = b.NUM_DOS';
5
6 dbms_mview.explain_rewrite
7 (
8 query => l_stmt,
9 mv => 'MIKEVW.SMV_SS_QRW',
10 statement_id => '123'
11 );
12 end;
13 /

Procédure PL/SQL terminée avec succès.

SQL> commit
2 /

Validation effectuée.

SQL> select message from rewrite_table
2 /

aucune ligne sélectionnée

thanks for your replies

Sidnet