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: Automic FIFO in Tables?

Re: Automic FIFO in Tables?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 20 Sep 2004 18:20:06 -0700
Message-ID: <1095729677.744611@yasure>


Caja wrote:

> Hi there,
>
> I heard something about the automatic, configurable deletion of old
> rows in tables in Ora 9i. This should take place in the CREATE TABLE syntax.
>
> Does someone knows about that?
> Thanks for any advice!
>
> Carsten

I've heard of it ... and the result of my investigation was to be pointed to sorted hash clusters which, at least to me, means that the functionality does not exist unless you sort on a timestamp column.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Sep 20 2004 - 20:20:06 CDT

Original text of this message

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