Query for shrinking datafile

  • From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 3 May 2010 09:49:17 +0200

Hi all,

do you use any query or method to discover how much space you can save on a
datafile? I want to say...suppose to shrink your datafile, which is the
minimum size, according to the highest HWM position, you can reach for your
datafile?

Which is the easiest way to achieve this?


Thanks
Ste

Other related posts: