Re: Limiting a # of rows in the table

Hi Dave & Andrey,

You can also limit the number of rows per block (at 8i) with the minimize records per block feature.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
From: "Dave A" <dave_and_vanna_at_hotmail.com>

I * think* so. If you aren't concerned about the exact number of rows, you could just limit the physical size of the table so it cant grow beyond a certain size. (next_extent size * max_extents=the max size the table can grow)

--
Dave A


"NetComrade " <andreyNSPAM_at_bookexchange.net> wrote in message
news:380a2e95.14873927_at_news.earthlink.net...


> is creating a trigger before insert and incrementing a # of rows for

> every insert and checking that number before every insert the only

> way?

>

> Thanx.