Re: [Q] Can you shrink tablespaces?

From: Winnie Liu <poohland_at_hotmail.com>
Date: Fri, 14 Aug 1998 22:58:18 -0700
Message-ID: <6r37pg$5rl@sjx-ixn4.ix.netcom.com>

can you really drop the data files that is not being used in a tablespace?

Winnie

Jonathan Gennick wrote in message
<35d72f37.13962258_at_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 Sat Aug 15 1998 - 00:58:18 CDT