Re: Table keeps growing inspite of purging

ORACLE's use and reuse of data blocks has not changed in a long time. I use V71523 and it behaves just fine as per pctfree and pctused. Perhaps there is a misunderstanding of what the question is.

ORACLE will reuse 'deleted' space in datablocks according to the pctfree and pctused parameters. See the Admin guide.

I routinely add (approx.) 100,000 new rows and delete 100,000 (7-month old) rows daily from each of 5-25+ million row tables. It works just fine. (My biggest concern is having to rebuild the indexes which as you can imagine get rather fragmented.)

-- 
Wayne Linton
lintonw_at_cadvision.com