By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Tables with a row size limit?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.