Well, I reduced the PCTUSED and PCTFREE on Friday and a small insert (app. 30,000 rows) seems to have worked as expected. No additional space was claimed and NUM_FREELIST_BLOCKS declined. I'll wait and see what happens during our next large insert. But for now it seems like changing these parameters may have resolved the problem. Jay Miller (with fingers crossed) -----Original Message----- Sent: Friday, December 06, 2002 4:19 PM To: Multiple recipients of list ORACLE-L
How badly do you want the space back? I believe you will indeed need to touch each row. You could update each row with something like (update .... set column-1=column-1) Good luck! Barb "Miller, Jay" <[EMAIL PROTECTED]> wrote: But will this solve my problem in the near term? My understanding is that simply changing the PCT USED won't move the problematic blocks off the freelist until some sort of DML touches the block. Am I correct in this and if so is there any way to resolve it? Jay _____ Do you Yahoo!? Yahoo! Mail <http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com> Plus - Powerful. Affordable. Sign up <http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com> now -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).