Re: Tables with a row size limit?

I've never heard of such a feature, and I've been dealing with Oracle for 5 years. The only way I can think of to achieve this is to limit the number of extents (MAXEXTENTS) of the table, if you know how many rows will be included in each block (and extent). But that would certainly not delete automatically the oldest rows.

Daniel

> I was told there is a feature in Oracle to set up a table to have a
> limit on the maximum number of rows in it. By attempt to insert more
> rows, the oldest rows should get deleted automatically.
>
> Is there a way to do it, other than writing my own insert trigger?
>
>
> Thanks,
>
> Dusan
Received on Wed Jul 16 2003 - 22:38:57 CEST