Home » Server Options » Replication » No changes when running DBMS_REFRESH
No changes when running DBMS_REFRESH [message #75458] Mon, 09 February 2004 04:10 Go to next message
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 Go to previous message
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,
Previous Topic: oracle 9i database synchronization
Next Topic: Nested materialized view ORA-12053
Goto Forum:
  


Current Time: Fri Mar 29 01:43:41 CDT 2024