>
>cape.net To: [EMAIL PROTECTED]
>
>Sent by: cc:
>
cc:
root@fatcity.Subject: Re: SPACE FREE HOW?
Seema,
with alter table deallocate, you can reclaim only the space above the high
water mark in a segment.
The only way the high water mark can be moved downward is to truncate the
segment or drop and recreate the segment.
Sunil Nookala
Dell Computer Corp.
Austin, TX
-Original Message
Hi Seema,
In a word NO. From the documentation:
Use the deallocate_unused_clause to explicitly deallocate unused space
at the end of the table, partition or subpartition, overflow data segment,
LOB data segment, or LOB index and makes the space available for other segments
in the tablespace.
Title: RE: SPACE FREE HOW?
Nick,
I have
a question regarding LiveReorg's method that prevents modifications to the
original table when it's time to switch to the newly reorged one. AS the
mechanism to prevent DML, LiveReorg creates a temporary trigger
on Insert, Update and D
ow to find HWM?
Thanks
-Seema
>From: "Post, Ethan" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: SPACE FREE HOW?
>Date: Thu, 17 Jan 2002 14:25:37 -0800
>
>Deleting records fro
Title: RE: SPACE FREE HOW?
24x7... that does make it tough.. you might want to try LiveReorg from Quest Software... it allows you to reorganize those tables while users are still accessing them. It will even tell you which tables to reorg to free up the most space... without even deleting
roach to do?
> DO u have any scripts how to find HWM?
> Thanks
> -Seema
>
>
>> From: "Post, Ethan" <[EMAIL PROTECTED]>
>> Reply-To: [EMAIL PROTECTED]
>> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>> Subject: RE: SPACE
Hi
Can I use following command to recover the space.
alter table deallocate unused;
I don't want to truncate and import.
Thx
-Seema
>From: "Ron Rogers" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
;[EMAIL PROTECTED]>
>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 statemen
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
Seema,
The table has set it'd HWM where the old data resided. The easiest?
method of recovering the space is to export the table and then truncate
the table followed by importing the table data back into the table. The
truncate function will remove all of the data and re-establish the size
back t
Unfortunately, your space will remain the same because delete
doesn't deallocate the free space allocated to the table whether
you shut the database down or not. The ways to deallocate space
would be to
a) Rebuild the table in another tablespace with significantly reduced
storage parameters (8
If you deleted rows, you can't see space unless untill you reoraganize that
objects..If you truncate you can see free space immediately!!
>From: "Seema Singh" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PRO
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
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
_
MSN Photos is the easiest way to sh
16 matches
Mail list logo
