Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: reinstate a snapshot

Re: reinstate a snapshot

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 18 Aug 1999 20:32:51 +0200
Message-ID: <935001193.25637.0.pluto.d4ee154e@news.demon.nl>


Look into the dbms_snapshot pl/sql package. It has a refresh procedure. As far as I remember, this also reinstates the job.

Hth,

Sybrand Bakker, Oracle DBA

pauldb <luapdbNOdySPAM_at_yahoo.com> wrote in message news:11f733ec.32b5618d_at_usw-ex0108-060.remarq.com...
> Hi,
>
> I have had a network error for the last day or so, and
> several snapshots were not updated. I looked in the
> user_jobs views and it shows the corresponding jobs to be
> broken.
>
> How do i re-instate the job now that the connection is re-
> established?
>
> Thanks a lot,
> Paul
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed Aug 18 1999 - 13:32:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US