| No changes when running DBMS_REFRESH [message #75458] |
Mon, 09 February 2004 04:10  |
ian
Messages: 27
Registered: September 1999
|
Junior Member |
|
|
I have materialzed view which is a member of a refresh group. When i run the following command:
call dbms_refresh.refresh('km_pt.blob_refresh_group')
I am told the call was completed successfully. However the data in the view has not changed in anyway, if i run the SELECT statement that the view is based on independently the changes on the master table are reflected in the retrieved data.
Is there any reason why this would be happening? My code for creating the view is:
CREATE MATERIALIZED VIEW "TEST"."BLOB_VIEW"
BUILD IMMEDIATE
REFRESH FORCE
ON DEMAND
AS
select bt.id, DV.PAGE_TYPE, BT.FILE from blob_tbl bt, data_view dv where dv.page_type=3 AND Dv.id=bt.id;
Thanks for any help.
|
|
|
|
| Re: No changes when running DBMS_REFRESH [message #75601 is a reply to message #75458] |
Tue, 04 January 2005 20:26  |
kifwet
Messages: 3
Registered: January 2005
|
Junior Member |
|
|
Ian,
If you don't have it already do the following:
Shuttdown the databse:
Perform the following tasks into the database
Add the following line to the ini<ora_sid>.ora file
JOB_QUEUE_PROCESSES=1
JOB_QUEUE_INTERVAL=10
and then restart the database
note:
JOB_QUEUE_PROCESSES is the number of the processes running in background.
JOB_QUEUE_INTERVAL is the frequency that the process is waked up to check the snapshots, and to refresh in case of need.(it's not the refresh frequency for the snapshot!)
I hope it will helps,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
