Re: [Q] Can you shrink tablespaces?

In article <6qu36d$r25$1_at_sunflower.man.poznan.pl>,   "Przemysław Pakulski" <przemop_at_talex.com.pl> wrote:
>
> Chris Muir napisał(a) w wiadomości: <35d27df8.155785938_at_mitswa>...
> >Howdy.
> >
> >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?
> >
> You can try following:
>
> ALTER TABLESPACE tablespace DATAFILE datafile RESIZE xxM
>
> where xx is the new size of datafile in MB.
>

You can only use this command (alter tablespace <..> datafile <..> resize <..>) if the COMPATIBLE parameter in your initSID.ora file has a parameter 7.2 or higher. Beware of that.

Winnie

> Przemo Pakulski
> przemop_at_talex.com.pl
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 13 1998 - 14:54:22 CDT