Materialized View - Oracle / Data is not updating

oracle materialized-views materialized
LozanoMatheus picture LozanoMatheus · May 23, 2016 · Viewed 8.3k times · Source

My friend has created a materialized view but the View does not receive new data from Mater Table. The view is receiving data only in creation, after it the news data are not included.

Anyone can help me to resolve this issue?

Fallow below my materialized view.

    CREATE or REPLACE MATERIALIZED VIEW DATABASE.MyMatView
    LOGGING
    TABLESPACE SDBANCO
    PCTFREE 10
    INITRANS 2
    STORAGE
    (
        INITIAL 65536
        NEXT 1048576
        MINEXTENTS 1
        MAXEXTENTS UNLIMITED
        BUFFER_POOL DEFAULT
    )
    NOCOMPRESS
    NOCACHE
    NOPARALLEL
    REFRESH ON DEMAND
    FORCE
    DISABLE QUERY REWRITE
AS
    SELECT * FROM .....

Thanks,

Matheus Lozano

Answer

mathguy picture mathguy · May 23, 2016

Assuming you did this but... just to be sure... you did issue the command to refresh the mview, right? You don't expect it to refresh by itself, when you have the option REFRESH ON DEMAND right there in the view definition, right?

Related questions

What is the difference between Views and Materialized Views in Oracle?

What is the difference between Views and Materialized Views in Oracle?

Read More
How to refresh materialized view in oracle

Iam trying to refresh the materialized view by using: DBMS_MVIEW.REFRESH('v_materialized_foo_tbl') But it's throwing invalid sql statement. Then I have created a stored procedure like this: CREATE OR REPLACE PROCEDURE MAT_VIEW_FOO_TBL IS …

Read More
Materialized Views - Identifying the last refresh

I presently access a series of views and materialized views. The materialized are maintained by a third party who offers little information regarding the frequency and success of the materialization. Of late the materialized views have failed to refresh and …

Read More