It has always bothered me that Oracle has the compress=Y option on exp, but not a
maximum initial extent size. We have a table that is larger then 2 gig and when you
create an export, the table can't be imported without pre creating the table. If they
had a max extent in exp, we could set it to maybe 1 gig and never have problems. The
problem is that an extent must exist in only one data file and most Unix OS's have a
max file size of 2 gig (though this is changing in new releases)
>>> SHAIBAL TALUKDER <[EMAIL PROTECTED]> 03/09/01 11:31AM >>>
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
>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-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).
---------------------------------
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
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).
