Tables with a row size limit?

[Dusan Chromy]

Hi,

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

[Daniel Roy]

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