| 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" not releasing space above HWM
How can one do this, simulate this case? How does one force initial
allocation and then deallocate? I've tried some trivial examples, but
can't seem to reproduce this situation. (I agree, this looks like a
highly unuseful feature.)
Adam
Mladen Gogala wrote:
>On 03/11/2004 03:32:38 PM, Adam Donahue wrote:
>
>
>>Is there a case where you can deallocate unused for a table other than
>>when you've manually allocated additional extents?
>>
>>Adam
>>
>>
>
>Well, yes, if the initial allocation was far too big, which is really
>a case similar to the one with manually added extents. To be entirely
>truthful, I consider "deallocate extents" command to be of very limited
>use. I studied it for my OCP, but have never had a chance to use it. Alter
>table move or DBMS_REDEFINITION are much more useful and DBMS_REDEFINE can
>even help you do the simple operations on the columns.
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Mar 11 2004 - 18:04:41 CST
 |
 |