| 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
I think the problem here is I'm testing on a LMT. The example below --
slightly modified ;) -- allocates a bunch of extents, but running a
deallocate unused immediately after the table creation doesn't release a
single one of them.
Adam
Mladen Gogala wrote:
>create table tbl (
> a number )
>tablespace test_tbs
>storage (initial 10m
> next 2048M
> pctincrease 0
> minextents 15);
>
>On 03/11/2004 07:02:25 PM, Adam Donahue wrote:
>
>
>>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
>>>-----------------------------------------------------------------
>>>
>>>
>>>
>>>
>>----------------------------------------------------------------
>>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:54:15 CST
 |
 |