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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
