Re: Automic FIFO in Tables?

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

Hans Forbrich wrote:

> 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 think you are looking for the Global Temporary Table definition. Either
> that or Advanced Queues (Oracle's name for message queues) which are
> implemented as using tables.
>
> Much more detail at htp://docs.oracle.com (and specifically for Oracle9iR2
> at http://www.oracle.com/pls/db92/db92.homepage)
>
> If the former, look at the SQL Reference Manual for syntax and details.
> Also look at Concepts Manual and DB Administrator's Guide for necessary
> background and conditions.
>
> If Advanced Queueing, I suggest the following docco, in order:
>
> Concepts
> Application Developer's Guide - Fundamentals
> Application Developer's Guide - Advanced Queuing
>
> /Hans

Sorry but no. I have checked my notes and I have an email from Mark Townsend identifying that FIFO claim as relating to sorted clusters.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Sep 20 2004 - 20:27:46 CDT