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 -> Moving datafiles, freeing space

Moving datafiles, freeing space

From: Chuck <chuckh_nospam_at_softhome.net>
Date: 2 Aug 2004 18:32:56 GMT
Message-ID: <Xns953993FFAC519chuckhnospamsofthome@130.133.1.4> 





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

-- 
Chuck
Remove "_nospam" to reply by email


Received on Mon Aug 02 2004 - 13:32:56 CDT












Original text of this message













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