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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 03 Aug 2004 06:38:29 -0400
Message-ID: <pan.2004.08.03.10.38.29.471246@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.

-- 
A city is a large community where people are lonesome together.
Received on Tue Aug 03 2004 - 05:38:29 CDT

Original text of this message

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