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 -> Re: Best way to clear stale data from very active audit tables

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

From: joel garry <joel-garry_at_home.com>
Date: Tue, 24 Jul 2007 06:39:35 -0700
Message-ID: <1185284375.018388.326990@i38g2000prf.googlegroups.com>


On Jul 24, 5:09 am, "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). What about if i used
> LOCALTIMESTAMP - i've done a quick scan and it might be because the
> CURRENT_TIMESTAMP is timezone specific, wheres the logdate is not. I
> can assume our app's clients all run in the same timezone (hopefully
> anyways!!!)... i'll give this a shot and i'll let you know what i
> find.

That sounds like a bad assumption!

jg

--
@home.com is bogus.
Wonder how Larry posts.  http://www.signonsandiego.com/uniontrib/20070721/news_1b21chats.html
Received on Tue Jul 24 2007 - 08:39:35 CDT

Original text of this message

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