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