| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re-claiming the space from Table after deleteion
Hi Rafi
This is the problem many big databases facing!!If you clean up the database every year and reorganizing the database You would't have see this scenario. For the matter fact iam also facing same problem, My one table grown like 22G, I simply can't do any thing?? Iam doing just for Indexes Rebuild for getting what ever space I can avail. As you said you deleted 40% of data!! You can reorganize your Indexes to avail some space.
Other wise Export to Tape and reimport it, But here again problem when you say compress=y, due to heavy data Its another big headche??
May be our friends give some ideas???????????????????
Thanks
Raghu.
>From: rafi_at_vsnl.net
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re-claiming the space from Table after deleteion
>Date: Fri, 09 Mar 2001 01:56:07 -0800
>
>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
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: rafi_at_vsnl.net
>
>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_at_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: Raghu Kota INET: raghukota_at_hotmail.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_at_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).Received on Fri Mar 09 2001 - 10:25:50 CST
 |
 |