Hi all,

I have a Oracle 7 Database where some of the Datafiles are huge in size although the %Free Space for the Tablespace is around 99%.

I am planning to Resize the Datafiles.

Can Some one tell me as to what are the parameters and criteria for calculating the Resizing Limit in the following Query.

ALTER DATABASE DATAFILE 'filename' RESIZE

What I need to know is if there is any way by means of which one can calculate a safe size for Downsizing the datafiles using the values for PCT_USED,FREE SPACE,USED SPACE ETC for each Datafile

Thanks