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?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
Adam
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/ FAQ is at //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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------