Query for shrinking datafile
From: Stefano Cislaghi <s.cislaghi_at_gmail.com>
Date: Mon, 3 May 2010 09:49:17 +0200
Message-ID: <t2zd06f0d321005030049zee0644edm2b1379626c2a2251_at_mail.gmail.com>
Hi all,
Date: Mon, 3 May 2010 09:49:17 +0200
Message-ID: <t2zd06f0d321005030049zee0644edm2b1379626c2a2251_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 03 2010 - 02:49:17 CDT