Home » Server Options » Replication » how to refresh snapshot and materized views?
how to refresh snapshot and materized views? [message #62800] Mon, 16 August 2004 02:01 Go to next message
fisher
Messages: 1
Registered: August 2004
Junior Member
  I create a db link for two DB(A,B). 

  and I create a snapshot in B to fetch data in A.

   Everything is ok, and i defiend every 5 minutes to refresh the

   snapshot.  but it is useless. how can do?

  else how can refresh the snapshot manually?

   Thanks!
Re: how to refresh snapshot and materized views? [message #62802 is a reply to message #62800] Mon, 16 August 2004 02:45 Go to previous messageGo to next message
Juergen
Messages: 7
Registered: August 2002
Junior Member
You can refresh the snapshot via

dbms_mview.refresh('snapshotname');

in database B.
Re: how to refresh snapshot and materized views? [message #62842 is a reply to message #62800] Wed, 18 August 2004 23:17 Go to previous message
Thomas
Messages: 67
Registered: September 1999
Member
If you created the MV, you should specified the refresh interval. This will create a DBMS_JOB which will refresh the MV.

Query the DBA_JOBS and see if the job was created and if it isn't BROKEN.

Hope that helps,

clio_usa - OCP DBA 8/8i/9i

Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups
Previous Topic: ORA-12008: error in materialized view refresh path
Next Topic: Materialized View Issue
Goto Forum:
  


Current Time: Fri Mar 29 06:54:32 CDT 2024