RE : Query for shrinking datafile

From: Bertrand Guillaumin <bertrand.guillaumin_at_digora.com>
Date: Mon, 3 May 2010 10:03:36 +0200
Message-ID: <7F06EBB9DB1FFD4BB233D8162D0F92572F19C97E63_at_athena.Digorix2.digora.com>

You can find the asktom queries in the following link : http://www.oracle.com/technology/oramag/oracle/04-sep/o54asktom.html

Go to the last paragraph.

You also have a query to know what at the end of the datafile.

But if you really need to shrink a datafile, you often have to do a reorg .

HTH

---

On 03/05/2010 10:49, Stefano Cislaghi wrote:
> 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-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 03 2010 - 03:03:36 CDT