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: Resize datafile not releasing space at OS level

RE: Resize datafile not releasing space at OS level

From: Best, David <David.Best_at_cognos.com>
Date: Fri, 9 Mar 2007 17:30:47 -0500
Message-ID: <2B4E386EAEC90947802323BF373DC0EC0BDBF516@sottemail1.ent.ad.cognos.com>


We have had this problem before.. I believe the solution was to unmount and remount the filesystem.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Friday, March 09, 2007 2:47 PM
To: oracle-l
Subject: Resize datafile not releasing space at OS level

Hi,

We have an Oracle 10.2.0.1 database on RHAT4 test server and I resize the file from 100G to 30G and operation is successful and I can see in the dba_data_file it is showing now as 30G but on hard drive/filesystem it is still showing 100G. So I assumed OS may release space when other process needs it but it didn't happened and other process failed for space reasons and also I rebooted the server but still no effect. What can be the possible reasoning for this behavior and how to reduce the size at file system level.

Thanks
--Harvinder

--

http://www.freelists.org/webpage/oracle-l  

     This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 09 2007 - 16:30:47 CST

Original text of this message

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