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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------



---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx 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 -----------------------------------------------------------------

Other related posts: