Re: Spacecheck for reorg

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 2 Nov 2002 03:18:16 +1100
Message-ID: <0Hxw9.67255$g9.188931@newsfeeds.bigpond.com>

No. And tablespaces don't shrink anyway, unless you manually resize the datafiles.

Also, there's zero need to re-organise a locally managed tablespace -so I'm assuming you are using dictionary managed tablespace, or have an early version of Oracle (pre-8i)??

HJR "Engin" <engin_at_web.de> wrote in message
news:3dc28d4f$0$189$4d4ebb8e_at_read.news.de.uu.net...
> Hi,
>
> I want to reorganize a tablespace. Is there a way to find out how much the
> the size of my tablespace will shrink, before doing the reorganize?
>
> Thanx,
>
> Hamit
>
>
Received on Fri Nov 01 2002 - 10:18:16 CST