Oracle-L: Re:how are the snapshots refreshed ?

From: <dgoulet_at_vicr.com>
Date: Mon, 04 Mar 2002 13:43:32 -0800
Message-ID: <F001.0041ECFA.20020304134332@fatcity.com>

Bunyamin,

OK, some of this may be a little off the wall since I'm at home on a day off. Can't believe I'm answering the mail on a day off!! But you got to do something while waiting for the glue to dry!!

Anyway, there are two init parameters that need to be set, job_queue_interval and job_queue_processes. After that bounce your database to start things. There after, the parameters you set for 'next' will take over. Now if you need to make changes, look in the user_jobs table. There you will find the next_date column and a procedure dbms_job.next_date to adjust matters.

Dick Goulet

____________________Reply Separator____________________
Author: "Bunyamin K. Karadeniz" <bunyamink_at_havelsan.com.tr>
Date:       3/4/2002 4:58 AM

Dear Gurus,

I have made 10 tables as snapshots . And I want to refresh them for specific intervals.
How can I do that ;
I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but could not succeed . How is it done ?
Bunyamin

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-9" http-equiv=Content-Type>
<META content="MSHTML 5.00.2014.210" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Dear Gurus,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I have made 10 tables as snapshots . And I want to
refresh them for specific intervals. </FONT></DIV>
<DIV><FONT face=Arial size=2>How can I do that ;</FONT></DIV>
<DIV><FONT face=Arial size=2>I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but
could not succeed . </FONT></DIV>
<DIV><FONT face=Arial size=2>How is it done ?</FONT></DIV>
<DIV><FONT face=Arial size=2>Bunyamin</FONT></DIV></BODY></HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Mar 04 2002 - 15:43:32 CST