Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re-claiming the space from Table after deleteion

RE: Re-claiming the space from Table after deleteion

From: Raghu Kota <raghukota_at_hotmail.com>
Date: Fri, 09 Mar 2001 10:29:24 -0800
Message-ID: <F001.002C889D.20010309101801@fatcity.com>

Mr Alex

You overlooked imp point that is oracle 7.3

>From: "Alex Hillman" <ahillman_at_erols.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Re-claiming the space from Table after deleteion
>Date: Fri, 09 Mar 2001 08:45:57 -0800
>
>First of all, as Joe Testa said - if you partitioned this table by date -
>let say one partition per month - you can truncate partitions that you
>don't
>need anymore. Second - if this option is not available - let say that you
>need delete most but not all records from specific partition - you can
>create temporary table, select into this table all records that should not
>be deleted, truncate partition and then select into partition all records
>from temporary table. And last case - if you need to delete let say 30-50%
>of the recors and this table does not have a lot of deletes in everyday
>activity and most deletes are batch in the end of month or some other
>period - you can increase value of PCTUSED to 100-PCTFREE-5.
>
>Alex Hillman
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> > rafi_at_vsnl.net
> > Sent: Friday, March 09, 2001 4:56 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re-claiming the space from Table after deleteion
> >
> >
> > 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: Alex Hillman
> INET: ahillman_at_erols.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).



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-- 
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 - 12:29:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US