I haven't seen anyone mention this yet, but I've been busy and not reading posts carefully. There is a KEEP clause you can tack on to the deallocate command that greatly enhances the usefulness of the command. > -----Original Message----- > > 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.) > ---------------------------------------------------------------- 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 -----------------------------------------------------------------