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 //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 -----------------------------------------------------------------