Re: timed update in Oracle

Hi Edoardo !

There are no problems to enable "sheduled" records deletion in a database. See dbms_job package description in
"Oracle Application Developer Guide" manual. This package allows to run stored procedures on time basis: hourly, daily or pursuant to your needs.

Regards !
Valery.

"edoardo.selva" wrote in message
<552D35D67B17D41187C20040C7995B8E1353A4_at_back-office.intertecnica.net>...
>Hi all.
>I have the following problem. I have to update a table on a timed basis,
>that is I have to delete lines when they are "older" than a fixed time (the
>timestamp is recorded in a column of the table). I thought about triggers,
>but it seems to me that they are not activable on timed events.
>This could be done writing an external application that periodically (e.g.,
>each hour) forces the SQL deletion of the lines where the difference
 (actual
>time - timestamp) is more than a fixed delay. Anyone can suggest a better
>solution, without involving external apps developing?
>
>Thank you in advance.
>
>Edoardo Selva
>
>Intertecnica Engineering Group
>Project Division
>
>
>--
>Posted from root_at_[195.120.85.10]
>via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Wed Nov 29 2000 - 18:23:35 CET