| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deallocate Unused
Hi Vidya,
"deallocate unused" will only deallocate extents up to the size specified by your initial/minexents storage allocation.
"deallocate unused keep blah" allows you to go below your initial allocation although it won't violate uniform extent size (LMT), minimum extent size (DMT), etc. limitations.
Cheers
Richard
----- Original Message -----
From: "vidya kalyanaraman" <vidya.kalyanaraman_at_oracle.com>
To: <oracle-l_at_freelists.org>
Sent: Thursday, February 19, 2004 10:22 PM
Subject: Deallocate Unused
Hi
While alterering the table to deallocate the extents which are above the
HWM, we did use the following command.
alter table <tab> deallocate unused;
Another DBA here feels that appending the DDL with "KEEP' keyword
is more beneficial. But he could not give any solid reason for doing so.
alter table <tab> deallocate unused keep 10M;
Can any one tell me how these two commands are different and which is
more efficient?
Scanned through Metalink, but could not find the correct answer for this
question.
Thanks in Advance
Vidya
 |
 |