Re: Re-claiming the space from Table after deleteion

yea in the table but not the index, since unless you put the exact same value for the row the index leaf node will NOT be reused, hence my statement about the partitioning.

Joe
William Beilstein wrote:
>
> 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" <teci_at_oracle-dba.com> 03/09/01 07:17AM >>>
> sounds like a candidate for partitioning.
>
> joe
> rafi_at_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_at_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_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: William Beilstein
> INET: BeilstWH_at_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_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).

-- 
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_at_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_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).