Re: Re-claiming the space from Table after deleteion

[SHAIBAL TALUKDER]

Raghu,

If you go with compress = y you will end up with one big initial extent which is not desirable specifically if you are talking about real big tables.

just my $0.02

Shaibal

  Raghu Kota <[EMAIL PROTECTED]> wrote:

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: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5! ! 051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

---

Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.