From BeilstWH@obg.com Fri, 09 Mar 2001 06:53:45 -0800 From: "William Beilstein" Date: Fri, 09 Mar 2001 06:53:45 -0800 Subject: Re: Re-claiming the space from Table after deleteion Message-ID: MIME-Version: 1.0 Content-Type: text/plain Also is this really a problem. In the next month you are going to import more rows which will use the deleted space anyway. >>> "Joseph S. Testa" 03/09/01 07:17AM >>> sounds like a candidate for partitioning. joe rafi@vsnl.net wrote: > > Dear All, > > Platform: Solaris 2.6, Oracle: 7.3.4.0 > > We have a few tables which are growing very fast due to large no of > insertions. But the data gets obselete after a month and we use a > procedure to delete the obselete data from the tables. > > The problem is that the table does not free the space even after the >deletion of 40% of the data. > > How can we re-claim the unused space which got created due to deletion? > > How do we ensure that future inserts are done in this unused space? > > [We can not try exp/imp or truncate option > due to the huge size & high activity and > online use of the tables]. > > Kind Regards and thanks to all there, > > Rafi Ahmad > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: teci@oracle-dba.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: BeilstWH@obg.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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).