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@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

On Wed, 09 Jul 2003 21:19:09 +0000, JamesLane <JamesLane03 (AT) yahoo (DOT) com>
wrote:


Sorry to ask, but you did make sure your job_queue_processes parameter
is nonzero prior to creating the mv?


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address