469,167 Members | 1,334 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Tables with a row size limit?

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
Jul 19 '05 #1
1 8553
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Lelle | last post: by
5 posts views Thread by Jefferis NoSpamme | last post: by
13 posts views Thread by ababeel | last post: by
2 posts views Thread by Bouzy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.