Re: Resize datafile not releasing space at OS level

<harvinder76_at_gmail.com> wrote in message news:1173473626.443157.20660_at_30g2000cwc.googlegroups.com...
> 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.
>
> select file_name,bytes from dba_data_files where tablespace_name='HS';
> /data233/oradata/hs1.dbf 32212254720
>
> -bash-3.00$ ls -lrt hs1*
> -rw-r----- 1 oracle oinstall 109521674240 Mar 9 15:49 hs1.dbf
>
> Thanks
> --Harvinder
>

Strange ... I once had this problem with jfs on AIX 5.2, the solution was then to stop all processes using the filesystem, and doing an umount/mount operation. Probably related to the filesystem type since I never had this on jfs2. Did you try unmount/mount on the fs ? Although rebooting the server would do the same thing.

Matthias Received on Sat Mar 10 2007 - 08:22:17 CST