Re: [Q] Can you shrink tablespaces?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 14 Aug 1998 02:52:24 GMT
Message-ID: <35d72f37.13962258@netnews.worldnet.att.net>

On Thu, 13 Aug 1998 05:49:29 GMT,
cmuir_at_mitswa.com.au.no.spam (Chris Muir) wrote:

>I currently have a tablespace that is 30% percent full. The data in
>the tablespace is static and wont change or grow. Is there a way to
>shrink the tablespace size to obtain the disk space back?

If the tablespace is made up of many data files, I believe that you can drop any that are unused. Otherwise, I'm not certain if you can shrink it or not. I don't think so.

Jonathan Received on Thu Aug 13 1998 - 21:52:24 CDT