Hi
While alterering the table to deallocate the extents which are above the
HWM, we did use the following command.
alter table <tab> deallocate unused;
Another DBA here feels that appending the DDL with "KEEP' keyword
is more beneficial. But he could not give any solid reason for doing so.
alter table <tab> deallocate unused keep 10M;
Can any one tell me how these two commands are different and which is
more efficient?
Scanned through Metalink, but could not find the correct answer for this
question.
Thanks in Advance
Vidya
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
Received on Thu Feb 19 2004 - 06:22:25 CST
