Re: Best way to clear stale data from very active audit tables

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Tue, 24 Jul 2007 13:01:48 GMT
Message-ID: <0Lmpi.11254$4A1.6063@news-server.bigpond.net.au>

<bobdurie_at_gmail.com> wrote in message
news:1185278974.918439.253010_at_o61g2000hsh.googlegroups.com...
> On Jul 23, 4:03 pm, "Chris L." <diver..._at_uol.com.ar> wrote:

>> On Jul 23, 4:36 pm, "bobdu..._at_gmail.com" <bobdu..._at_gmail.com> wrote:
>>
>>

> I don't want to use the SYSDATE as its a DATE and that is NOT going to
> translate well when the retention period is smaller, ie a few hours
> (not for this table but for others).

You do know that a DATE datatype can be translated to the nearest second don't you ?

SQL> select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS') date_and_time from dual;

DATE_AND_TIME

---

24-07-2007 23:02:55

Cheers

Richard Received on Tue Jul 24 2007 - 08:01:48 CDT