Materialized View not automatically refreshing

From: JamesLane <JamesLane03_at_yahoo.com>
Date: Wed, 09 Jul 2003 21:19:09 +0000
Message-ID: <3092619.1057785549@dbforums.com>

I have been playing around with materialized views and I have created one that simply views a table on a remote database. It works fine, but I programmed it to refresh ever hour and it is not... I created the same view on the local database and everything worked correctly with refreshing. What's going on? Here is the script:

CREATE MATERIALIZED VIEW MJV.AS_MVW_INVENTORY_ASSETS_REMOTE

        PCTFREE 10 PCTUSED 40 INITRANS 2 MAXTRANS 255
        STORAGE(
                INITIAL 128 K
                NEXT 128 K
                MINEXTENTS 1
                MAXEXTENTS 4096
                PCTINCREASE 0
                FREELISTS 1
                FREELIST GROUPS 1
                BUFFER_POOL DEFAULT


                )

TABLESPACE USERS
LOGGING
NOCACHE
NOPARALLEL

USING INDEX     PCTFREE 10 INITRANS 2 MAXTRANS 255
        STORAGE(
                BUFFER_POOL DEFAULT


                )

REFRESH FORCE
        ON DEMAND
        START WITH TO_DATE('09-Jul-2003 13:40:56','dd-mon-yyyy
        hh24:mi:ss')
        NEXT SYSDATE + 1/24
        WITH ROWID

 USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS
SELECT s.* FROM SNFLWR_REPOS.AS_QY_INVENTORY_ASSETS_at_asset_link s

I am using TOAD and under Jobs it lists the refresh to occur every hour, but when the time comes... and passes... nothing happens. The job does not update either.

Thank you for any help

--
Posted via http://dbforums.com

Received on Wed Jul 09 2003 - 16:19:09 CDT