Re: SPACE FREE HOW?

The dba_space package has routines that will tell you wherer the hwm mark. With
that infomration and 1.75 you can get a cup of coffee :-). Knowing "where" the
HWM mark is, is not helpful. The only way to move it, is to truncate the table.
I know this is difficult in a 24X7 system but frankly is unavoidable.

BTW, you have a perfect situation for a partitioned table based on months. Then
instead of deleting date you can drop the partition.

John
oracledbam_at_hotmail.com wrote:

> Ethan
> The database is in production and users are accesing 24x7.What will be
> best approach to do?
> DO u have any scripts how to find HWM?
> Thanks
> -Seema
>
>
>> From: "Post, Ethan" <Ethan.Post_at_ps.net>
>> Reply-To: ORACLE-L_at_fatcity.com
>> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> Subject: RE: SPACE FREE HOW?
>> Date: Thu, 17 Jan 2002 14:25:37 -0800
>>
>> Deleting records from a table does not free up space in the database.
>> Search for high water mark in the concepts manual and you should find an
>> explanation of how this works. The statement below only frees up space
>> above the high water mark on the table.
>>
>> You can...
>>
>> create table foo nologging as (select * from big_table);
>>
>> truncate table big_table;
>>
>> insert into big_table (select * from foo);
>>
>> drop table foo;
>>
>>
>> -Ethan
>>
>> -----Original Message-----
>> Sent: Thursday, January 17, 2002 3:27 PM
>> To: Multiple recipients of list ORACLE-L
>>
>>
>> ALTER TABLE table DEALLOCATE UNUSED KEEP integer;
>> the keep clause is optional.
>>
>> -sunil
>>
>> -----Original Message-----
>> Sent: Thursday, January 17, 2002 2:58 PM
>> To: Multiple recipients of list ORACLE-L
>>
>>
>> Hi
>> I deleted millions of rows from diffrent tables and I have not seen any
>> impact on database size.What I have to do to get that free space?
>> Is it necessary to shutdown the database?
>> Thx
>> -Seema
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Post, Ethan
>> INET: Ethan.Post_at_ps.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).
>
>
>
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  INET: orantdba_at_netscape.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).