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

Home -> Community -> Usenet -> c.d.o.server -> trigger & snapshot

trigger & snapshot

From: sofresud <sofresud_at_wanadoo.fr>
Date: Thu, 13 Jan 2000 09:31:41 +0100
Message-ID: <85k2mk$9u1$1@wanadoo.fr>


Hi,

I would like to execute special pl-sql procedure every day at a special time. the way i foud to do that is to create a snapshot that runs at the given time , and create a trigger on the table created by the snapshot, then the pl-sql procedure is the trigger body. Is there a another way to do a such thing ?? (better way)

Thanks.

Stephane SANDOZ Received on Thu Jan 13 2000 - 02:31:41 CST

Original text of this message

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