Materialized View Not Refresh

[dihan]

MY TEST TABLE LIKE THAT
SQL> SELECT * FROM TEST;

ID NAME
---------- ----------
1 A
2 B

SQL> DESC TEST
Name Null? Type
------------------------------- -------- ----------
ID NOT NULL NUMBER
NAME VARCHAR2(10)


I CREATE THE MATERIALIZED VIEW LOG LIKE...

SQL> CREATE MATERIALIZED VIEW LOG ON TEST
2 WITH PRIMARY KEY,ROWID;

Materialized view log created.

THAN I CREATE MATERIALIZED VIEW LIKE ....

SQL> CREATE MATERIALIZED VIEW TEST_VIEW
2 REFRESH FAST ON COMMIT AS SELECT ID,NAME
3 FROM TEST;

Materialized view created.

SQL> SELECT * FROM TEST_VIEW;

ID NAME
---------- ----------
1 A
2 B

--INSERT A NEW ROW..

SQL> INSERT INTO TEST1 VALUES(3,C);

1 row created.

SQL> COMMIT;

Commit complete.

THAN I REFERSH THE MATERIALIZED VIEW....

SQL> EXECUTE DBMS_MVIEW.REFRESH('TEST_VIEW');

PL/SQL procedure successfully completed.

BUT WHAN I QUARY THE MATERIALIZE VIEW I DIDNT SEE THE NEW RECORD.

SQL> SELECT * FROM TEST_VIEW;

ID NAME
---------- ----------
1 A
2 B

PLEASE TELL ME WHERE I MISTAKE...
THANKS

[PAVB]

That's correct, your MV is showing what it has to show.

Here is why...
1- Your MV points to TEST table.
2- You are inserting into TEST1 table.
3-

[dihan]

sorry sir, yes i was inserted test1 table.

but now i insert data test table, but i didnt see new record in materialize view.

i dont know where my mistake, or it is the right procedure refrash materialize view.

thanks.

[dihan]

im new in oracle,

so anyone know any other option how materialize view are refresh

please tell me .

thanks