Re: [Q] Can you shrink tablespaces?

I don't know if the command that you have given will work or not.

But this will definitely work:

alter database datafile '/u1/.../.../...' resize XXM;

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

Przemysław Pakulski <przemop_at_talex.com.pl> wrote in article <6qu36d$r25$1_at_sunflower.man.poznan.pl>...
>
> 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.
>
> Przemo Pakulski
> przemop_at_talex.com.pl
>
>
>
>
Received on Thu Aug 13 1998 - 09:46:43 CDT