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

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving datafiles, freeing space

Re: Moving datafiles, freeing space

From: Chuck <chuckh_nospam_at_softhome.net>
Date: 3 Aug 2004 13:12:16 GMT
Message-ID: <Xns953A5DA207E9Achuckhnospamsofthome@130.133.1.4>


Mladen Gogala <gogala_at_sbcglobal.net> wrote in news:pan.2004.08.03.10.38.29.471246_at_sbcglobal.net:

> On Mon, 02 Aug 2004 18:32:56 +0000, Chuck wrote:
> 

>> After moving an oracle datafile, it sometimes takes hours or even
>> days for the space to become free in the filesystem that the datafile
>> was moved from. Why is this? Is there a way force Oracle to release
>> this space without restarting the instance?
>>
>> Platform AIX 4.3, Oracle 8.1.7.4
> 
> Unmount the file system and re-mount it again.
> 

This is a 24x7x364 production database. There are other datafiles on that filesystem. Unmounting and remounting are not an option. Neither is bouncing the instance which also frees up the space immediately.

-- 
Chuck
Remove "_nospam" to reply by email
Received on Tue Aug 03 2004 - 08:12:16 CDT

Original text of this message

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