From oracle-l-bounce@freelists.org Thu Mar 11 18:04:41 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2C04fh03537 for ; Thu, 11 Mar 2004 18:04:41 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2C04fo03532 for ; Thu, 11 Mar 2004 18:04:41 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9750C396993; Thu, 11 Mar 2004 19:01:20 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 18:59:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from listproc.corp.opsware.com (olly.opsware.com [66.54.20.10]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B228D396848 for ; Thu, 11 Mar 2004 18:57:15 -0500 (EST) Received: from opsware.com (dhcp-8-111.corp.loudcloud.com [192.168.8.111]) by listproc.corp.opsware.com (8.12.10/8.12.5) with ESMTP id i2C02P2X008089 for ; Thu, 11 Mar 2004 16:02:25 -0800 (PST) Message-ID: <4050FE11.7000701@opsware.com> Date: Thu, 11 Mar 2004 16:02:25 -0800 From: Adam Donahue User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: "Deallocate Unused" not releasing space above HWM References: <564DE4477544D411AD2C00508BDF0B6A1CE0AA3D@USAHM018.amer.corp.eds.com> <4050CCE6.1020302@opsware.com> <20040311224543.GA3098@mladen.wangtrading.com> In-Reply-To: <20040311224543.GA3098@mladen.wangtrading.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-archive-position: 584 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: adonahue@opsware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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@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 >----------------------------------------------------------------- > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------