]
Sent by: cc:
root@fatcity.Subject: Re: SPACE FREE HOW
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
Hi
Can I use following command to recover the space.
alter table tablename 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 PROTECTED]
Subject: Re: SPACE FREE HOW
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 FREE HOW?
Date: Thu, 17 Jan 2002 14:25:37 -0800
Deleting records from a table does not free up space
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
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 from a table does not free up space in the database.
Search
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 createsa temporary trigger
on Insert, Update and Delete
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.
:
root@fatcity.Subject: Re: SPACE FREE HOW?
com
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
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
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
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
13 matches
Mail list logo