| 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
Provided all extents of the desired table are in same size, the incoming
data should use the free space.
regards;
Uttam majumdar
-----Original Message-----
Sent: Friday, March 09, 2001 4:56 AM
To: Multiple recipients of list ORACLE-L
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).
PG&E National Energy Group and any other
company referenced herein that uses the PG&E name or
logo are not the same company as Pacific Gas and
Electric Company, the regulated California utility. Neither
PG&E National Energy Group nor these other
referenced companies are regulated by the California Public
Utilities Commission. Customers of Pacific Gas and Electric Company
do not have to buy products from these companies in order
to continue to receive quality regulated services from the utility.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Majumdar, Uttam
INET: uttam.majumdar_at_neg.pge.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 - 08:51:39 CST
 |
 |