Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: "Deallocate Unused" not releasing space above HWM

Re: "Deallocate Unused" not releasing space above HWM

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Wed, 10 Mar 2004 10:24:49 -0500
Message-ID: <20040310152449.GG1761@mladen.wangtrading.com>


On 03/10/2004 10:05:51 AM, Ron Rogers wrote:
> Mladen,
> You are 100% correct in you statement about reclaiming the unused
> space. I would also suggest that the data be exported before the
> truncation followed by an import or you can practice the recovery
> policy that you have established.
> Ron

Hey, practice makes us perfect, doesn't it? If truncate command is used at an inopportune moment, the DBA will come as close to perfection or joblessness as humanly possible.



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 Wed Mar 10 2004 - 09:24:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US