Originally posted by anandkl
You cannot decrease the size of an existing datafile..only option u have is to re-create a new datafile with the new size...
This is not true.

You can decrease the size of a data file as long as you don't try to shrink it past the point where it contains data.