RE: Resize datafile not releasing space at OS level

Thanks for the reply.  

We are not using the recyle option and parameter recyclebin is off. No error during file shrink. It was created a Bigfile/LMT  

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    

From: GovindanK [mailto:gkatteri_at_fastmail.fm] Sent: Friday, March 09, 2007 5:10 PM
To: Harvinder Singh; oracle-l
Subject: Re: Resize datafile not releasing space at OS level  

May be you would need to Purge the Recycle bin. Are you using Bigfile/DMT/LMT?

Refer to Metalink Notes Note:380473.1, Note:1061937.6

Are you receiving any error while shrinking?

HTH GovindanK

On Fri, 9 Mar 2007 14:47:08 -0500, oracle-l-bounce_at_freelists.org said:
> 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
>
> --
> www.freelists.org/webpage/oracle-l
>
>

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