Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting a # of rows in the table

Re: Limiting a # of rows in the table

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Tue, 17 Oct 2000 20:26:04 -0500
Message-ID: <supup3h8ofrn9e@corp.supernews.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.
Received on Tue Oct 17 2000 - 20:26:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US