You have to query the data dictionary views, then find the min size you can shrink the datafile. A ready to use script is posted Here (Script for calculating the MAX size to which datafile can shrink )


Hope that helps,

clio_usa

OCP 8/8i/9i DBA